Spreadsheet: 546038d1509814678-time-calculations-holiday-pay-01
Sheet: Sheet1

 |  |  | Plus Hrs |  | Base |  | Hrs+Per Day
A | 53 Wk | 261 |  |  |  |  | 00:08:24 | 1 |  |  | 00:42:00 |  |  | 260
B | 52 Wk | 260 | 2303 |  | 2043 |  | 00:08:24 | 2 |  |  |  |  |  | 261
B | -33 Days holiday |  |  |  |  |  | 00:08:24 | 3
A | -33 Days holiday |  |  |  |  |  | 00:08:24 | 4
 |  |  |  |  |  |  | 00:08:24 | 5
 |  |  |  |  |  |  | 00:08:24 | 6
 |  |  |  |  |  |  | 00:08:24 | 7
 |  |  | £/Hr | 13.44 |  |  | 00:08:24 | 8
 |  |  |  |  |  |  | 00:08:24 | 9
 |  |  |  |  |  |  | 00:08:24 | 10
 |  |  |  |  |  |  | 00:08:24 | 11 |  |  |  |  |  |  |  | 365 | Days/year
 |  |  |  |  |  |  | 00:08:24 | 12 |  |  |  |  |  |  |  |  | Work Days/Year(+Holidays)
 |  |  |  |  |  |  | 00:08:24 | 13 |  |  |  |  |  |  |  |  | Work Days/Year(-Holidays)
 |  |  |  |  |  |  | 00:08:24 | 14
 |  |  |  |  |  |  | 00:08:24 | 15 |  |  |  |  |  |  |  |  | Walkers Minutes
 |  |  |  |  |  |  | 00:08:24 | 16 |  |  |  |  |  |  |  | 10:09:00 | Actual Minutes
 |  |  |  |  |  |  | 00:08:24 | 17
 |  |  |  |  |  |  | 00:08:24 | 18
 |  |  |  |  |  |  | 00:08:24 | 19 |  |  |  |  |  | Monday→Friday
 |  |  |  |  |  |  | 00:08:24 | 20 |  |  |  |  |  | 2008-2009 | 2009-2010 | 2010-2011 | 2011-2012 | 2012-2013 | 2013-2014 | 2014-2015 | 2015-2016 | 2016-2017 | 2017-2018
 |  |  |  |  |  |  | 00:08:24 | 21 |  |  |  |  |  | 365 | 365 | 365 | 366 | 365 | 365 | 365 | 366 | 365 | 365
 |  |  |  |  |  |  | 00:08:24 | 22 |  |  |  |  |  | 261 | 261 | 261 | 261 | 260 | 261 | 261 | 263 | 261 | 260
 |  |  |  |  |  |  | 00:08:24 | 23 |  |  |  |  |  | 228 | 228 | 228 | 228 | 226 | 228 | 228 | 230 | 228 | 227
 |  |  |  |  |  |  | 00:08:24 | 24
 |  |  |  |  |  |  | 00:08:24 | 25
 |  |  |  |  |  |  | 00:08:24 | 26
 |  |  |  |  |  |  | 00:08:24 | 27
 |  |  |  |  |  |  | 00:08:24 | 28
 |  |  |  |  |  |  | 00:08:24 | 29
 |  |  |  |  |  |  | 00:08:24 | 30
 |  |  |  |  |  |  | 00:08:24 | 31
 |  |  |  |  |  |  | 00:08:24 | 32
 |  |  |  |  |  |  | 00:08:24 | 33
 |  |  |  |  |  |  | 00:08:24 | 34
 |  |  |  |  |  |  | 00:08:24 | 35
 |  |  |  |  |  |  | 00:08:24 | 36
 |  |  |  |  |  |  | 00:08:24 | 37
 |  |  |  |  |  |  | 00:08:24 | 38
 |  |  |  |  |  |  | 00:08:24 | 39
 |  |  |  |  |  |  | 00:08:24 | 40
 |  |  |  |  |  |  | 00:08:24 | 41
 |  |  |  |  |  |  | 00:08:24 | 42
 |  |  |  |  |  |  | 00:08:24 | 43
 |  |  |  |  |  |  | 00:08:24 | 44
 |  |  |  |  |  |  | 00:08:24 | 45
 |  |  |  |  |  |  | 00:08:24 | 46
 |  |  |  |  |  |  | 00:08:24 | 47
 |  |  |  |  |  |  | 00:08:24 | 48
 |  |  |  |  |  |  | 00:08:24 | 49
 |  |  |  |  |  |  | 00:08:24 | 50
 |  |  |  |  |  |  | 00:08:24 | 51
 |  |  |  |  |  |  | 00:08:24 | 52
 |  |  |  |  |  |  | 00:08:24 | 53
 |  |  |  |  |  |  | 00:08:24 | 54
 |  |  |  |  |  |  | 00:08:24 | 55
 |  |  |  |  |  |  | 00:08:24 | 56
 |  |  |  |  |  |  | 00:08:24 | 57
 |  |  |  |  |  |  | 00:08:24 | 58
 |  |  |  |  |  |  | 00:08:24 | 59
 |  |  |  |  |  |  | 00:08:24 | 60
 |  |  |  |  |  |  | 00:08:24 | 61
 |  |  |  |  |  |  | 00:08:24 | 62
 |  |  |  |  |  |  | 00:08:24 | 63
 |  |  |  |  |  |  | 00:08:24 | 64
 |  |  |  |  |  |  | 00:08:24 | 65
 |  |  |  |  |  |  | 00:08:24 | 66
 |  |  |  |  |  |  | 00:08:24 | 67
 |  |  |  |  |  |  | 00:08:24 | 68
 |  |  |  |  |  |  | 00:08:24 | 69
 |  |  |  |  |  |  | 00:08:24 | 70
 |  |  |  |  |  |  | 00:08:24 | 71
 |  |  |  |  |  |  | 00:08:24 | 72
 |  |  |  |  |  |  | 00:08:24 | 73
 |  |  |  |  |  |  | 00:08:24 | 74
 |  |  |  |  |  |  | 00:08:24 | 75
 |  |  |  |  |  |  | 00:08:24 | 76
 |  |  |  |  |  |  | 00:08:24 | 77
 |  |  |  |  |  |  | 00:08:24 | 78
 |  |  |  |  |  |  | 00:08:24 | 79
 |  |  |  |  |  |  | 00:08:24 | 80
 |  |  |  |  |  |  | 00:08:24 | 81
 |  |  |  |  |  |  | 00:08:24 | 82
 |  |  |  |  |  |  | 00:08:24 | 83
 |  |  |  |  |  |  | 00:08:24 | 84
 |  |  |  |  |  |  | 00:08:24 | 85
 |  |  |  |  |  |  | 00:08:24 | 86
 |  |  |  |  |  |  | 00:08:24 | 87
 |  |  |  |  |  |  | 00:08:24 | 88
 |  |  |  |  |  |  | 00:08:24 | 89
 |  |  |  |  |  |  | 00:08:24 | 90
 |  |  |  |  |  |  | 00:08:24 | 91
 |  |  |  |  |  |  | 00:08:24 | 92
 |  |  |  |  |  |  | 00:08:24 | 93
 |  |  |  |  |  |  | 00:08:24 | 94
 |  |  |  |  |  |  | 00:08:24 | 95
 |  |  |  |  |  |  | 00:08:24 | 96
 |  |  |  |  |  |  | 00:08:24 | 97
 |  |  |  |  |  |  | 00:08:24 | 98
 |  |  |  |  |  |  | 00:08:24 | 99
 |  |  |  |  |  |  | 00:08:24 | 100
 |  |  |  |  |  |  | 00:08:24 | 101
 |  |  |  |  |  |  | 00:08:24 | 102
 |  |  |  |  |  |  | 00:08:24 | 103
 |  |  |  |  |  |  | 00:08:24 | 104
 |  |  |  |  |  |  | 00:08:24 | 105
 |  |  |  |  |  |  | 00:08:24 | 106
 |  |  |  |  |  |  | 00:08:24 | 107
 |  |  |  |  |  |  | 00:08:24 | 108
 |  |  |  |  |  |  | 00:08:24 | 109
 |  |  |  |  |  |  | 00:08:24 | 110
 |  |  |  |  |  |  | 00:08:24 | 111
 |  |  |  |  |  |  | 00:08:24 | 112
 |  |  |  |  |  |  | 00:08:24 | 113
 |  |  |  |  |  |  | 00:08:24 | 114
 |  |  |  |  |  |  | 00:08:24 | 115
 |  |  |  |  |  |  | 00:08:24 | 116
 |  |  |  |  |  |  | 00:08:24 | 117
 |  |  |  |  |  |  | 00:08:24 | 118
 |  |  |  |  |  |  | 00:08:24 | 119
 |  |  |  |  |  |  | 00:08:24 | 120
 |  |  |  |  |  |  | 00:08:24 | 121
 |  |  |  |  |  |  | 00:08:24 | 122
 |  |  |  |  |  |  | 00:08:24 | 123
 |  |  |  |  |  |  | 00:08:24 | 124
 |  |  |  |  |  |  | 00:08:24 | 125
 |  |  |  |  |  |  | 00:08:24 | 126
 |  |  |  |  |  |  | 00:08:24 | 127
 |  |  |  |  |  |  | 00:08:24 | 128
 |  |  |  |  |  |  | 00:08:24 | 129
 |  |  |  |  |  |  | 00:08:24 | 130
 |  |  |  |  |  |  | 00:08:24 | 131
 |  |  |  |  |  |  | 00:08:24 | 132
 |  |  |  |  |  |  | 00:08:24 | 133
 |  |  |  |  |  |  | 00:08:24 | 134
 |  |  |  |  |  |  | 00:08:24 | 135
 |  |  |  |  |  |  | 00:08:24 | 136
 |  |  |  |  |  |  | 00:08:24 | 137
 |  |  |  |  |  |  | 00:08:24 | 138
 |  |  |  |  |  |  | 00:08:24 | 139
 |  |  |  |  |  |  | 00:08:24 | 140
 |  |  |  |  |  |  | 00:08:24 | 141
 |  |  |  |  |  |  | 00:08:24 | 142
 |  |  |  |  |  |  | 00:08:24 | 143
 |  |  |  |  |  |  | 00:08:24 | 144
 |  |  |  |  |  |  | 00:08:24 | 145
 |  |  |  |  |  |  | 00:08:24 | 146
 |  |  |  |  |  |  | 00:08:24 | 147
 |  |  |  |  |  |  | 00:08:24 | 148
 |  |  |  |  |  |  | 00:08:24 | 149
 |  |  |  |  |  |  | 00:08:24 | 150
 |  |  |  |  |  |  | 00:08:24 | 151
 |  |  |  |  |  |  | 00:08:24 | 152
 |  |  |  |  |  |  | 00:08:24 | 153
 |  |  |  |  |  |  | 00:08:24 | 154
 |  |  |  |  |  |  | 00:08:24 | 155
 |  |  |  |  |  |  | 00:08:24 | 156
 |  |  |  |  |  |  | 00:08:24 | 157
 |  |  |  |  |  |  | 00:08:24 | 158
 |  |  |  |  |  |  | 00:08:24 | 159
 |  |  |  |  |  |  | 00:08:24 | 160
 |  |  |  |  |  |  | 00:08:24 | 161
 |  |  |  |  |  |  | 00:08:24 | 162
 |  |  |  |  |  |  | 00:08:24 | 163
 |  |  |  |  |  |  | 00:08:24 | 164
 |  |  |  |  |  |  | 00:08:24 | 165
 |  |  |  |  |  |  | 00:08:24 | 166
 |  |  |  |  |  |  | 00:08:24 | 167
 |  |  |  |  |  |  | 00:08:24 | 168
 |  |  |  |  |  |  | 00:08:24 | 169
 |  |  |  |  |  |  | 00:08:24 | 170
 |  |  |  |  |  |  | 00:08:24 | 171
 |  |  |  |  |  |  | 00:08:24 | 172
 |  |  |  |  |  |  | 00:08:24 | 173
 |  |  |  |  |  |  | 00:08:24 | 174
 |  |  |  |  |  |  | 00:08:24 | 175
 |  |  |  |  |  |  | 00:08:24 | 176
 |  |  |  |  |  |  | 00:08:24 | 177
 |  |  |  |  |  |  | 00:08:24 | 178
 |  |  |  |  |  |  | 00:08:24 | 179
 |  |  |  |  |  |  | 00:08:24 | 180
 |  |  |  |  |  |  | 00:08:24 | 181
 |  |  |  |  |  |  | 00:08:24 | 182
 |  |  |  |  |  |  | 00:08:24 | 183
 |  |  |  |  |  |  | 00:08:24 | 184
 |  |  |  |  |  |  | 00:08:24 | 185
 |  |  |  |  |  |  | 00:08:24 | 186
 |  |  |  |  |  |  | 00:08:24 | 187
 |  |  |  |  |  |  | 00:08:24 | 188
 |  |  |  |  |  |  | 00:08:24 | 189
 |  |  |  |  |  |  | 00:08:24 | 190
 |  |  |  |  |  |  | 00:08:24 | 191
 |  |  |  |  |  |  | 00:08:24 | 192
 |  |  |  |  |  |  | 00:08:24 | 193
 |  |  |  |  |  |  | 00:08:24 | 194
 |  |  |  |  |  |  | 00:08:24 | 195
 |  |  |  |  |  |  | 00:08:24 | 196
 |  |  |  |  |  |  | 00:08:24 | 197
 |  |  |  |  |  |  | 00:08:24 | 198
 |  |  |  |  |  |  | 00:08:24 | 199
 |  |  |  |  |  |  | 00:08:24 | 200
 |  |  |  |  |  |  | 00:08:24 | 201
 |  |  |  |  |  |  | 00:08:24 | 202
 |  |  |  |  |  |  | 00:08:24 | 203
 |  |  |  |  |  |  | 00:08:24 | 204
 |  |  |  |  |  |  | 00:08:24 | 205
 |  |  |  |  |  |  | 00:08:24 | 206
 |  |  |  |  |  |  | 00:08:24 | 207
 |  |  |  |  |  |  | 00:08:24 | 208
 |  |  |  |  |  |  | 00:08:24 | 209
 |  |  |  |  |  |  | 00:08:24 | 210
 |  |  |  |  |  |  | 00:08:24 | 211
 |  |  |  |  |  |  | 00:08:24 | 212
 |  |  |  |  |  |  | 00:08:24 | 213
 |  |  |  |  |  |  | 00:08:24 | 214
 |  |  |  |  |  |  | 00:08:24 | 215
 |  |  |  |  |  |  | 00:08:24 | 216
 |  |  |  |  |  |  | 00:08:24 | 217
 |  |  |  |  |  |  | 00:08:24 | 218
 |  |  |  |  |  |  | 00:08:24 | 219
 |  |  |  |  |  |  | 00:08:24 | 220
 |  |  |  |  |  |  | 00:08:24 | 221
 |  |  |  |  |  |  | 00:08:24 | 222
 |  |  |  |  |  |  | 00:08:24 | 223
 |  |  |  |  |  |  | 00:08:24 | 224
 |  |  |  |  |  |  | 00:08:24 | 225
 |  |  |  |  |  |  | 00:08:24 | 226
 |  |  |  |  |  |  | 00:08:24 | 227
 |  |  |  |  |  |  | 00:08:24 | 228
 |  |  |  |  |  |  | 00:08:24 | 229
 |  |  |  |  |  |  | 00:08:24 | 230
 |  |  |  |  |  |  | 00:08:24 | 231
 |  |  |  |  |  |  | 00:08:24 | 232
 |  |  |  |  |  |  | 00:08:24 | 233
 |  |  |  |  |  |  | 00:08:24 | 234
 |  |  |  |  |  |  | 00:08:24 | 235
 |  |  |  |  |  |  | 00:08:24 | 236
 |  |  |  |  |  |  | 00:08:24 | 237
 |  |  |  |  |  |  | 00:08:24 | 238
 |  |  |  |  |  |  | 00:08:24 | 239
 |  |  |  |  |  |  | 00:08:24 | 240
 |  |  |  |  |  |  | 00:08:24 | 241
 |  |  |  |  |  |  | 00:08:24 | 242
 |  |  |  |  |  |  | 00:08:24 | 243
 |  |  |  |  |  |  | 00:08:24 | 244
 |  |  |  |  |  |  | 00:08:24 | 245
 |  |  |  |  |  |  | 00:08:24 | 246
 |  |  |  |  |  |  | 00:08:24 | 247
 |  |  |  |  |  |  | 00:08:24 | 248
 |  |  |  |  |  |  | 00:08:24 | 249
 |  |  |  |  |  |  | 00:08:24 | 250
 |  |  |  |  |  |  | 00:08:24 | 251
 |  |  |  |  |  |  | 00:08:24 | 252
 |  |  |  |  |  |  | 00:08:24 | 253
 |  |  |  |  |  |  | 00:08:24 | 254
 |  |  |  |  |  |  | 00:08:24 | 255
 |  |  |  |  |  |  | 00:08:24 | 256
 |  |  |  |  |  |  | 00:08:24 | 257
 |  |  |  |  |  |  | 00:08:24 | 258
 |  |  |  |  |  |  | 00:08:24 | 259
 |  |  |  |  |  |  | 00:08:24 | 260