Spreadsheet: 819517d1677555626-formula-for-pesky-time-formats-loadout-log-template
Sheet: Wednesday

Date | Division | Route | Hauler | Trailer Number | Scheduled Depart Time (Route Sheet) | NEW Estimated Load Completed Time | Actual Load Completion Time | Time Load Departed Dairy | Shift | Load Start Time | Load Finish Time | Load Duration | Case Count | Pallet Count | Trailer Temp | Reason For Downtime | Comments
2023-02-15 00:00:00 | Central | 407 | Penske | 8641 | 11:20:00 |  | 06:45:00 | 10:27:00 |  | 06:30:00 | 06:45:00 |  | 897 | 17 | 43.1 | 5:30-6:00 PICKERS
2023-02-15 00:00:00 | Central | 408 | Penske | 8654 | 11:38:00 |  | 07:20:00 | 10:52:00 |  | 07:00:00 | 07:20:00 |  | 1140 | 22 | 39.7
2023-02-15 00:00:00 | Central | 409 | Penske | 8605 | 12:01:00 |  | 08:00:00 | 13:43:00 |  | 07:40:00 | 08:00:00 |  | 1162 | 23 | 40.8 | 6:45-7:00 SQR
2023-02-15 00:00:00 | Central | 410 | Penske | 8618 | 13:00:00 |  | 08:15:00 | 11:03:00 |  | 08:00:00 | 08:15:00 |  | 1135 | 23 | 45.5
2023-02-15 00:00:00 | Central | 411 | QWC | 3127 | 13:34:00 |  | 09:00:00 | 10:30:00 |  | 08:35:00 | 09:00:00 |  | 1142 | 23 | 44.8 | 7:20-7:40 WAITING ON KONG DRIVER
2023-02-15 00:00:00 | Central | 412 | Penske | 8636 | 14:17:00 |  | 10:00:00 | 16:11:00 |  | 09:40:00 | 10:00:00 |  | 1053 | 21 | 42.7
2023-02-15 00:00:00 | Central | 413 | Penske | 8633 | 15:00:00 |  | 10:40:00 | 16:48:00 |  | 10:20:00 | 10:40:00 |  | 1155 | 24 | 38.9 | 8:15-8:35 WAITING ON KONG DRIVER
2023-02-15 00:00:00 | Central | 414 | QWC | 3157 | 15:00:00 |  | 11:00:00 |  |  | 10:40:00 | 11:00:00 |  | 1112 | 21 | 44.4
2023-02-15 00:00:00 | Central | 415 | QWC | 3134 | 16:30:00 |  | 11:30:00 | 19:30:00 |  | 11:00:00 | 11:30:00 |  | 1252 | 25 | 42.6 | 9:00-9:30 BREAK
2023-02-15 00:00:00 | Central | 416 | QWC | 8602 | 17:30:00 |  | 13:15:00 | 17:11:00 |  | 12:50:00 | 13:15:00 |  | 913 | 18 | 39.2
2023-02-15 00:00:00 | Ruler | C10 | QWC | 8772 | 19:00:00 |  | 14:20:00 | 19:08:00 |  | 13:50:00 | 14:20:00 |  | 1163 | 25 | 40.8 | 10:00-10:20 TRACK 1 CHAIN OFF
2023-02-15 00:00:00 | Ruler | C11 | QWC | 235 | 19:30:00 |  | 17:00:00 | 19:24:00 |  | 16:00:00 | 17:00:00 |  | 1161 | 26 | 41
2023-02-15 00:00:00 | [NAME] | J08 | Penske | 8617 | 05:00:00 |  | 17:30:00 |  |  | 17:00:00 | 17:30:00 |  | 486 | 9 | 42.4 | 11:30-12:00 WAITING ON TRAILERS
2023-02-15 00:00:00 | Central | 501 | Penske | 8604 | 02:00:00 |  | 17:45:00 |  |  | 17:30:00 | 17:45:00 |  | 248 | 5 | 40.8
2023-02-15 00:00:00 | Central | 502 | Penske | 8647 | 03:11:00 |  | 18:00:00 |  |  | 17:45:00 | 18:00:00 |  | 560 | 11 | 42 | 12:00-12:30 LUNCH
2023-02-15 00:00:00 | Mariano's | M09 | Penske | 8609 | 04:07:00 |  | 19:50:00 | 21:57:00 |  | 18:25:00 | 19:50:00 |  | 1101 | 24 | 41.5
2023-02-15 00:00:00 | Mariano's | M10 | Penske | 8661 | 05:39:00 |  | 20:25:00 |  |  | 19:50:00 | 20:25:00 |  | 925 | 18 | 42 | 1:15-1:50 SENDING OUT CHOCOLATE MILK
2023-02-15 00:00:00 | Central | 503 | QWC | 8662 | 09:34:00 |  | 21:45:00 |  |  | 20:25:00 | 21:05:00 |  | 915 | 19 | 41.5
2023-02-15 00:00:00 | Central | 504 | QWC | 8637 | 09:40:00 |  | 22:10:00 |  |  | 21:45:00 | 22:10:00 |  | 1180 | 24 | 42 | 2:20-2:50 BREAK
2023-02-15 00:00:00 | Central | 505 | QWC | 8659 | 10:56:00 |  | 22:30:00 |  |  | 22:10:00 | 22:30:00 |  | 1174 | 23 | 42
2023-02-15 00:00:00 | Central | 506 | Penske | 8628 | 11:04:00 |  | 22:55:00 |  |  | 22:30:00 | 22:55:00 |  | 1198 | 23 | 41 | 2:50-3:50 WAITING ON DOOR 10
2023-02-15 00:00:00 | Central | 507 | Penske | 8258 | 12:00:00 |  | 23:20:00 |  |  | 22:55:00 | 23:20:00 |  | 1232 | 24 | 41.5 | 6:05-6:25 BREAK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:10-7:20 PALLETIZER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9:10-9:40 LUNCH