Spreadsheet: 791574d1660471156-find-hours-between-set-hours-trip-info-master-blank-test
Sheet: Weekly Total

 | Sunday |  |  |  | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Saturday |  |  |  |  |  |  |  | TIMINGS |  |  | COSTING
Drivers | Start |  | Finish | Total Hrs | Start | Finish | Total Hrs | Start | Finish | Total Hrs | Start | Finish | Total Hrs | Start | Finish | Total Hrs | Start | Finish | Total Hrs | Start | Finish | Total Hrs | Weekly Total Hrs | Breaks | Weekly Total Hrs Less Breaks | Core Hours |  | Basic Hrs | [NAME] | Night Hrs | [NAME] | Hourly Cost | Overtime Rate | Overtime Cost | Early Start Rate | Overtime Cost | Total Cost | Agency Cost | Diff
P Singleton |  |  |  | 00:00:00 | 06:00:00 | 16:00:00 | 10:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 10:00:00 | 00:30:00 | 09:30:00 | 1 day, 12:00:00 | 07:30:00 | 07:30:00 | 02:00:00
B Rutherford |  |  |  | 00:00:00 | 05:00:00 | 15:00:00 | 10:00:00 | 05:00:00 | 16:30:00 | 11:30:00 | 05:00:00 | 16:30:00 | 11:30:00 | 05:00:00 | 15:00:00 | 10:00:00 | 05:00:00 | 14:30:00 | 09:30:00 |  |  | 00:00:00 | 2 days, 4:30:00 | 02:30:00 | 2 days, 2:00:00 | 1 day, 12:00:00 | 1 day, 13:30:00 | 1 day, 12:00:00 | 14:00:00
[NAME] |  |  |  | 00:00:00 | 06:00:00 | 15:00:00 | 09:00:00 | 06:00:00 | 14:00:00 | 08:00:00 | 06:00:00 | 14:00:00 | 08:00:00 | 06:00:00 | 14:00:00 | 08:00:00 | 06:00:00 | 13:30:00 | 07:30:00 |  |  | 00:00:00 | 1 day, 16:30:00 | 02:30:00 | 1 day, 14:00:00 | 1 day, 12:00:00 | 1 day, 13:30:00 | 1 day, 12:00:00 | 02:00:00
S Yeates |  |  |  | 00:00:00 | 06:00:00 | 18:15:00 | 12:15:00 | 06:00:00 | 16:30:00 | 10:30:00 | 06:00:00 | 12:45:00 | 06:45:00 | 06:00:00 | 14:15:00 | 08:15:00 | 06:00:00 | 14:30:00 | 08:30:00 |  |  | 00:00:00 | 1 day, 22:15:00 | 02:30:00 | 1 day, 19:45:00 | 1 day, 13:30:00 | 1 day, 13:30:00 | 1 day, 13:30:00 | 06:15:00
V Angelov |  |  |  | 00:00:00 | 06:00:00 | 16:00:00 | 10:00:00 | 06:00:00 | 15:00:00 | 09:00:00 | 05:00:00 | 17:30:00 | 12:30:00 | 06:00:00 | 15:15:00 | 09:15:00 | 05:00:00 | 15:00:00 | 10:00:00 |  |  | 00:00:00 | 2 days, 2:45:00 | 02:30:00 | 2 days, 0:15:00 | 1 day, 13:30:00 | 1 day, 13:30:00 | 1 day, 13:30:00 | 10:45:00
J Cartwright |  |  |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 06:00:00 | 15:15:00 | 09:15:00 | 06:00:00 | 14:15:00 | 08:15:00 |  |  | 00:00:00 | 17:30:00 | 01:00:00 | 16:30:00 | 1 day, 13:30:00 | 15:00:00 | 15:00:00 | 01:30:00
P Roberts |  |  |  | 00:00:00 | 06:00:00 | 15:00:00 | 09:00:00 | 06:00:00 | 18:00:00 | 12:00:00 | 06:00:00 | 15:00:00 | 09:00:00 | 06:00:00 | 16:00:00 | 10:00:00 | 06:00:00 | 15:15:00 | 09:15:00 |  |  | 00:00:00 | 2 days, 1:15:00 | 02:30:00 | 1 day, 22:45:00 | 1 day, 13:30:00 | 1 day, 13:30:00 | 1 day, 13:30:00 | 09:15:00
C [NAME] |  |  |  | 00:00:00 | 06:00:00 | 16:15:00 | 10:15:00 | 06:00:00 | 15:30:00 | 09:30:00 | 06:00:00 | 15:15:00 | 09:15:00 | 06:00:00 | 12:15:00 | 06:15:00 | 06:00:00 | 13:30:00 | 07:30:00 |  |  | 00:00:00 | 1 day, 18:45:00 | 02:30:00 | 1 day, 16:15:00 | 1 day, 13:30:00 | 1 day, 13:30:00 | 1 day, 13:30:00 | 02:45:00
T White |  |  |  | 00:00:00 | 06:00:00 | 16:00:00 | 10:00:00 | 06:00:00 | 18:00:00 | 12:00:00 | 06:00:00 | 17:30:00 | 11:30:00 | 06:00:00 | 14:30:00 | 08:30:00 | 06:00:00 | 13:00:00 | 07:00:00 |  |  | 00:00:00 | 2 days, 1:00:00 | 02:30:00 | 1 day, 22:30:00 | 1 day, 13:30:00 | 1 day, 13:30:00 | 1 day, 13:30:00 | 09:00:00
K Davidson |  |  |  | 00:00:00 | 06:00:00 | 15:15:00 | 09:15:00 | 06:00:00 | 14:45:00 | 08:45:00 | 06:00:00 | 17:30:00 | 11:30:00 | 05:00:00 | 17:30:00 | 12:30:00 | 05:00:00 | 18:30:00 | 13:30:00 |  |  | 00:00:00 | 2 days, 7:30:00 | 02:30:00 | 2 days, 5:00:00 | 1 day, 13:30:00 | 1 day, 13:30:00 | 1 day, 13:30:00 | 15:30:00
J Mulligan |  |  |  | 00:00:00 | 18:00:00 | 21:30:00 | 03:30:00 | 14:30:00 | 01:30:00 | 11:00:00 | 17:30:00 | 00:00:00 | 06:30:00 | 15:15:00 | 01:45:00 | 10:30:00 | 15:00:00 | 01:15:00 | 10:15:00 |  |  | 00:00:00 | 1 day, 17:45:00 | 02:30:00 | 1 day, 15:15:00 | 1 day, 13:30:00 | 1 day, 13:30:00 | 1 day, 13:30:00 | 01:45:00
P Bennett |  |  |  | 00:00:00 | 14:30:00 | 22:30:00 | 08:00:00 | 14:30:00 | 23:30:00 | 09:00:00 | 14:30:00 | 22:00:00 | 07:30:00 | 14:30:00 | 22:15:00 | 07:45:00 | 14:30:00 | 21:30:00 | 07:00:00 |  |  | 00:00:00 | 1 day, 15:15:00 | 02:30:00 | 1 day, 12:45:00 | 1 day, 13:30:00 | 1 day, 13:30:00 | 1 day, 13:30:00 | 00:00:00
[NAME] |  |  |  | 00:00:00 | #N/A | #N/A | 08:00:00 | #N/A | #N/A | 08:00:00 | #N/A | #N/A | 08:00:00 | #N/A | #N/A | 08:00:00 | #N/A | #N/A | 08:00:00 |  |  | 00:00:00 | 1 day, 16:00:00 | 02:30:00 | 1 day, 13:30:00 | 1 day, 13:30:00 | 1 day, 13:30:00 | 1 day, 13:30:00 | 00:00:00