Spreadsheet: 756528d1637614490-agency-spend-audit-agency-audit
Sheet: Sheet1

AGENCY | Block No | DRIVERS NAME | DATE | Start Time @ Yard | VEHICLE REG | Depot Time | HOURS WORK ED | HOURLY RATE | Invoice Amount | Day | Start D/T | Start D/T + Hours worked = Finish D/T | Hours worked at Day rate | Hours worked at Night rate | Total Pay due |  | Night Shift | 16:00 to 04:01
 |  |  | 2021-11-07 00:00:00 | 02:11:00 |  |  | 6.17 | 28.27 |  |  |  |  |  |  |  |  | Hourly Rates
 |  |  | 2021-11-07 00:00:00 | 03:01 |  |  | 9.36 | 28.27 |  |  |  |  |  |  |  |  | Days | 24.31
 |  |  | 2021-11-07 00:00:00 | 12:00 |  |  | 7.21 | 28.27 |  |  |  |  |  |  |  |  | Nights | 25.63
 |  |  | 2021-11-08 00:00:00 | 01:43:00 |  |  | 6.11 | 24.31 |  |  |  |  |  |  |  |  | Saturday all day | 26.95
 |  |  | 2021-11-08 00:00:00 | 03:00 |  |  | 11.44 | 24.31 |  |  |  |  |  |  |  |  | Sunday all day | 28.27
 |  |  | 2021-11-08 00:00:00 | 20:50 |  |  | 9.5 | 25.63
 |  |  | 2021-11-09 00:00:00 | 00:01 |  |  | 10.41 | 24.31
 |  |  | 2021-11-09 00:00:00 | 01:00 |  |  | 7.45 | 25.63
 |  |  | 2021-11-09 00:00:00 | 01:42:00 |  |  | 12.07 | 24.31
 |  |  | 2021-11-09 00:00:00 | 05:30 |  |  | 10 | 24.31
 |  |  | 2021-11-09 00:00:00 | 08:30 |  |  | 9.29 | 24.31
 |  |  | 2021-11-09 00:00:00 | 11:00:00 |  |  | 11.44 | 24.31
 |  |  | 2021-11-09 00:00:00 | 17:14:00 |  |  | 10.21 | 24.31
 |  |  | 2021-11-09 00:00:00 | 20:12 |  |  | 11.19 | 25.63
 |  |  | 2021-11-09 00:00:00 | 20:37 |  |  | 8.03 | 25.63
 |  |  | 2021-11-10 00:00:00 | 00:13 |  |  | 6.02 | 25.63
 |  |  | 2021-11-10 00:00:00 | 03:00 |  |  | 11 | 24.31
 |  |  | 2021-11-10 00:00:00 | 08:45 |  |  | 8.45 | 24.31
 |  |  | 2021-11-10 00:00:00 | 11:00:00 |  |  | 12 | 24.31
 |  |  | 2021-11-10 00:00:00 | 15:04 |  |  | 9.57 | 24.31
 |  |  | 2021-11-10 00:00:00 | 18:00 |  |  | 11.1 | 25.63
 |  |  | 2021-11-10 00:00:00 | 20:19 |  |  | 12.15 | 25.63
 |  |  | 2021-11-10 00:00:00 | 20:50 |  |  | 9.1 | 25.63
 |  |  | 2021-11-10 00:00:00 | 23:07 |  |  | 6.39 | 25.63
 |  |  | 2021-11-11 00:00:00 | 00:00 |  |  | 6.3 | 25.63
 |  |  | 2021-11-11 00:00:00 | 01:32 |  |  | 4.38 | 25.63
 |  |  | 2021-11-11 00:00:00 | 03:22:00 |  |  | 10:42:00 | 24.31
 |  |  | 2021-11-11 00:00:00 | 05:30 |  |  | 9.3 | 24.31
 |  |  | 2021-11-11 00:00:00 | 12:57 |  |  | 12.41 | 24.31
 |  |  | 2021-11-11 00:00:00 | 13:30:00 |  |  | 11 | 24.31
 |  |  | 2021-11-11 00:00:00 | 19:35 |  |  | 12.4 | 25.63
 |  |  | 2021-11-11 00:00:00 | 20:32 |  |  | 12.12 | 25.63
 |  |  | 2021-11-11 00:00:00 | 20:40:00 |  |  | 9.23 | 25.63
 |  |  | 2021-11-11 00:00:00 | 23:05 |  |  | 9.34 | 25.63
 |  |  | 2021-11-12 00:00:00 | 01:00 |  |  | 9 | 24.31
 |  |  | 2021-11-12 00:00:00 | 01:46:00 |  |  | 11.15 | 24.31
 |  |  | 2021-11-12 00:00:00 | 07:45 |  |  | 6.45 | 24.31
 |  |  | 2021-11-12 00:00:00 | 17:45:00 |  |  | 5.24 | 24.31
 |  |  | 2021-11-12 00:00:00 | 19:42 |  |  | 11.03 | 25.63
 |  |  | 2021-11-12 00:00:00 | 20:16 |  |  | 10.57 | 25.63
 |  |  | 2021-11-12 00:00:00 | 20:26 |  |  | 11.54 | 25.63
 |  |  | 2021-11-12 00:00:00 | 23:06:00 |  |  | 9.23 | 25.63
 |  |  | 2021-11-13 00:00:00 | 01:50:00 |  |  | 11.58 | 26.95
 |  |  | 2021-11-13 00:00:00 | 02:58:00 |  |  | 10.02 | 26.95
 |  |  | 2021-11-13 00:00:00 | 12:05:00 |  |  | 14.14 | 26.95
 |  |  | 2021-11-13 00:00:00 | 13:30:00 |  |  | 11.15 | 26.95
 |  |  | 2021-11-13 00:00:00 | 20:03 |  |  | 11.52 | 26.95
 |  |  | 2021-11-13 00:00:00 | 21:57 |  |  | 9.32 | 26.95