Spreadsheet: 269543d1381194604-formula-involving-times-not-working-for-specific-hours-e-g-22-00-scratch
Sheet: RAW

 |  | Proc | Actual
 |  |  |  | Total
 |  |  |  | Grand Total |  |  |  |  |  |  |  |  |  |  |  | 0 | After midnight
 | Date | Hour | Hour |  |  |  |  |  |  |  |  |  |  |  |  | 1 | After midnight
2011-07-01 00:00:00 | 2011-07-01 | 0:00 | 0:00 | 1 |  |  |  |  |  |  |  |  |  |  |  | 2 | After midnight
2011-07-01 00:00:00 | 2011-07-01 | 1:00 | 0:00 | 169 |  |  |  |  |  |  |  |  |  |  |  | 3 | After midnight
2011-07-01 00:00:00 | 2011-07-01 | 2:00 | 2:00 | 147 |  |  |  |  |  |  |  |  |  |  |  | 4 | After midnight
2011-07-01 00:00:00 | 2011-07-01 | 2:00 | 2:00 | 104 |  |  |  |  |  |  |  |  |  |  |  | 5 | After midnight
2011-07-01 00:00:00 | 2011-07-01 | 3:00 | 3:00 | 106 |  |  |  |  |  |  |  |  |  |  |  | 6 | Morning
2011-07-01 00:00:00 | 2011-07-01 | 6:00 | 3:00 | 4 |  |  |  |  |  |  |  |  |  |  |  | 7 | Morning
2011-07-01 00:00:00 | 2011-07-01 | 5:00 | 5:00 | 261 |  |  |  |  |  |  |  |  |  |  |  | 8 | Morning
2011-07-01 00:00:00 | 2011-07-01 | 6:00 | 5:00 | 2 |  |  |  |  |  |  |  |  |  |  |  | 9 | Morning
2011-07-01 00:00:00 | 2011-07-01 | 5:00 | 4:00 | 261 |  |  |  |  |  |  |  |  |  |  |  | 10 | Morning
2011-07-01 00:00:00 | 2011-07-01 | 5:00 | 5:00 | 216 |  |  |  |  |  |  |  |  |  |  |  | 11 | Morning
2011-07-01 00:00:00 | 2011-07-01 | 6:00 | 5:00 | 164 |  |  |  |  |  |  |  |  |  |  |  | 12 | Afternoon
2011-07-01 00:00:00 | 2011-07-01 | 6:00 | 6:00 | 222 |  |  |  |  |  |  |  |  |  |  |  | 13 | Afternoon
2011-07-01 00:00:00 | 2011-07-01 | 7:00 | 6:00 | 2 |  |  |  |  |  |  |  |  |  |  |  | 14 | Afternoon
2011-07-01 00:00:00 | 2011-07-01 | 5:00 | 5:00 | 57 |  |  |  |  |  |  |  |  |  |  |  | 15 | Afternoon
2011-07-01 00:00:00 | 2011-07-01 | 6:00 | 5:00 | 185 |  |  |  |  |  |  |  |  |  |  |  | 16 | Evening
2011-07-01 00:00:00 | 2011-07-01 | 6:00 | 6:00 | 204 |  |  |  |  |  |  |  |  |  |  |  | 17 | Evening
2011-07-01 00:00:00 | 2011-07-01 | 7:00 | 6:00 | 10 |  |  |  |  |  |  |  |  |  |  |  | 18 | Evening
2011-07-01 00:00:00 | 2011-07-01 | 8:00 | 8:00 | 271 |  |  |  |  |  |  |  |  |  |  |  | 19 | Evening
2011-07-01 00:00:00 | 2011-07-01 | 9:00 | 8:00 | 82 |  |  |  |  |  |  |  |  |  |  |  | 20 | Night
2011-07-01 00:00:00 | 2011-07-01 | 9:00 | 9:00 | 269 |  |  |  |  |  |  |  |  |  |  |  | 21 | Night
2011-07-01 00:00:00 | 2011-07-01 | 9:00 | 10:00 | 2 |  |  |  |  |  |  |  |  |  |  |  | 22 | Night
2011-07-01 00:00:00 | 2011-07-01 | 10:00 | 10:00 | 167 |  |  |  |  |  |  |  |  |  |  |  | 23 | Night
2011-07-01 00:00:00 | 2011-07-01 | 11:00 | 10:00 | 256
2011-07-01 00:00:00 | 2011-07-01 | 11:00 | 11:00 | 189
2011-07-01 00:00:00 | 2011-07-01 | 12:00 | 11:00 | 61
2011-07-01 00:00:00 | 2011-07-01 | 9:00 | 11:00 | 6
2011-07-01 00:00:00 | 2011-07-01 | 9:00 | 12:00 | 1
2011-07-01 00:00:00 | 2011-07-01 | 12:00 | 11:00 | 455
2011-07-01 00:00:00 | 2011-07-01 | 12:00 | 12:00 | 334
2011-07-01 00:00:00 | 2011-07-01 | 13:00 | 11:00 | 4
2011-07-01 00:00:00 | 2011-07-01 | 13:00 | 12:00 | 60
2011-07-01 00:00:00 | 2011-07-01 | 14:00 | 14:00 | 162
2011-07-01 00:00:00 | 2011-07-01 | 12:00 | 12:00 | 66
2011-07-01 00:00:00 | 2011-07-01 | 13:00 | 12:00 | 85
2011-07-01 00:00:00 | 2011-07-01 | 14:00 | 14:00 | 319
2011-07-01 00:00:00 | 2011-07-01 | 15:00 | 14:00 | 10
2011-07-01 00:00:00 | 2011-07-01 | 13:00 | 13:00 | 238
2011-07-01 00:00:00 | 2011-07-01 | 14:00 | 13:00 | 315
2011-07-01 00:00:00 | 2011-07-01 | 14:00 | 14:00 | 167
2011-07-01 00:00:00 | 2011-07-01 | 15:00 | 14:00 | 74
2011-07-01 00:00:00 | 2011-07-01 | 15:00 | 15:00 | 325
2011-07-01 00:00:00 | 2011-07-01 | 15:00 | 15:00 | 173
2011-07-01 00:00:00 | 2011-07-01 | 16:00 | 15:00 | 104
2011-07-01 00:00:00 | 2011-07-01 | 16:00 | 16:00 | 142
2011-07-01 00:00:00 | 2011-07-01 | 16:00 | 15:00 | 192
2011-07-01 00:00:00 | 2011-07-01 | 16:00 | 16:00 | 107
2011-07-01 00:00:00 | 2011-07-01 | 17:00 | 17:00 | 64
2011-07-01 00:00:00 | 2011-07-01 | 18:00 | 17:00 | 31
2011-07-01 00:00:00 | 2011-07-01 | 17:00 | 17:00 | 287
2011-07-01 00:00:00 | 2011-07-01 | 18:00 | 17:00 | 627
2011-07-01 00:00:00 | 2011-07-01 | 18:00 | 17:00 | 126
2011-07-01 00:00:00 | 2011-07-01 | 18:00 | 18:00 | 109
2011-07-01 00:00:00 | 2011-07-01 | 20:00 | 20:00 | 388
2011-07-01 00:00:00 | 2011-07-01 | 21:00 | 20:00 | 89
2011-07-01 00:00:00 | 2011-07-01 | 21:00 | 21:00 | 131
2011-07-01 00:00:00 | 2011-07-01 | 22:00 | 21:00 | 10
2011-07-01 00:00:00 | 2011-07-01 | 21:00:00 | 21:00:00 | 126
2011-07-01 00:00:00 | 2011-07-01 | 22:00:00 | 21:00:00 | 34
2011-07-01 00:00:00 | 2011-07-01 | 22:00:00 | 22:00:00 | 5
2011-07-01 00:00:00 | 2011-07-01 | 23:00:00 | 22:00:00 | 410
2011-07-01 00:00:00 | 2011-07-01 | 00:00:00 | 00:00:00 | 293
2011-07-01 00:00:00 | 2011-07-01 | 00:00:00 | 23:00:00 | 263
2011-07-01 00:00:00 | 2011-07-01 | 04:00:00 | 04:00:00 | 146
2011-07-01 00:00:00 | 2011-07-01 | 23:00:00 | 23:00:00 | 236