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

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-14 00:00:00 | Central | 303 |  | 8654 | 09:28:00 |  | 06:50:00 | 10:24:00 |  | 06:20:00 | 06:50:00 |  | 1055 | 21 | 38 | 6:00-6:20 WAITING ON UNITIZER
2023-02-14 00:00:00 | Central | 304 |  | 8638 | 10:48:00 |  | 07:10:00 | 15:38:00 |  | 06:50:00 | 07:10:00 |  | 1159 | 22 | 35.5 | 8:50-9:15 CHAIN OFF
2023-02-14 00:00:00 | Central | 305 |  | 8642 | 11:02:00 |  | 07:30:00 | 11:39:00 |  | 07:10:00 | 07:30:00 |  | 1221 | 24 | 36 | 9:15-9:40 BREAK
2023-02-14 00:00:00 | Central | 306 |  | 8645 | 11:27:00 |  | 08:00:00 | 11:30:00 |  | 07:30:00 | 08:00:00 |  | 1167 | 23 | 36 | 10:20-11:25 CHAIN OFF
2023-02-14 00:00:00 | Central | 307 |  | 8602 | 12:00:00 |  | 08:30:00 | 17:04:00 |  | 08:00:00 | 08:50:00 |  | 1214 | 24 | 36.5 | 12:10-12:45 LUNCH
2023-02-14 00:00:00 | Central | 308 |  | 8648 | 13:41:00 |  | 10:20:00 | 06:29:00 |  | 09:40:00 | 10:20:00 |  | 1158 | 22 | 35 | 2:30-3:00 BREAK
2023-02-14 00:00:00 | Central | 309 |  | 8604 | 15:02:00 |  | 11:50:00 | 14:35:00 |  | 11:25:00 | 11:50:00 |  | 1175 | 23 | 41 | 6:05-6:25 BREAK
2023-02-14 00:00:00 | Central | 310 |  | 8627 | 15:27:00 |  | 12:10:00 | 23:37:00 |  | 11:50:00 | 12:10:00 |  | 1092 | 22 | 52.5 | LUNCH 9:25-9:55
2023-02-14 00:00:00 | Central | 311 |  | 8617 | 17:06:00 |  | 13:10:00 | 17:30:00 |  | 12:45:00 | 13:10:00 |  | 1257 | 24 | 37.5 | CHANGING BATTERY
2023-02-14 00:00:00 | Central | 312 |  | 8618 | 18:22:00 |  | 13:45:00 | 16:58:00 |  | 13:10:00 | 13:45:00 |  | 1254 | 22 | 38
2023-02-14 00:00:00 | Central | 313 |  | 8639 | 18:30:00 |  | 14:10:00 | 23:32:00 |  | 13:45:00 | 14:10:00 |  | 1281 | 24 | 39.5
2023-02-14 00:00:00 | Central | 314 |  | 3157 | 19:00:00 |  | 14:30:00 | 20:21:00 |  | 14:10:00 | 14:30:00 |  | 1295 | 23 | 36.5
2023-02-14 00:00:00 | Ruler | C07 |  | 316352 | 19:00:00 |  | 15:45:00 | 16:44:00 |  | 15:00:00 | 15:45:00 |  | 1169 | 22 | 38
2023-02-14 00:00:00 | Ruler | C08 |  | 316350 | 19:30:00 |  | 17:05:00 | 17:31:00 |  | 16:10:00 | 17:05:00 |  | 1242 | 26 | 39.3
2023-02-14 00:00:00 | Ruler | C09 |  | 316351 | 20:00:00 |  | 18:00:00 | 21:36:00 |  | 17:05:00 | 18:00:00 |  | 940 | 20 | 37.4
2023-02-14 00:00:00 | [NAME] | [NAME] |  | 8614 | 05:00:00 |  | 19:30:00 |  |  | 18:25:00 | 19:30:00 |  | 1186 | 25 | 40.5
2023-02-14 00:00:00 | [NAME] | J06 |  | 8632 | 05:00:00 |  | 20:05:00 |  |  | 19:30:00 | 20:05:00 |  | 996 | 20 | 37.5
2023-02-14 00:00:00 | [NAME] | J07 |  | 8626 | 05:00:00 |  | 20:35:00 |  |  | 20:05:00 | 20:35:00 |  | 970 | 18 | 42
2023-02-14 00:00:00 | Central | 402 |  | 8615 | 09:05:00 |  | 21:05:00 |  |  | 20:35:00 | 21:05:00 |  | 1241 | 24 | 42
2023-02-14 00:00:00 | Central | 403 |  | 8642 | 09:32:00 |  | 01:05:00 |  |  | 00:00:00 | 01:05:00 |  | 1224 | 25 | 41.5
2023-02-14 00:00:00 | Central | 404 |  | 8663 | 10:00:00 |  | 01:40:00 |  |  | 01:05:00 | 01:40:00 |  | 942 | 23 | 42
2023-02-14 00:00:00 | Central | 405 |  | 8658 | 10:51:00 |  | 02:15:00 |  |  | 01:40:00 | 02:15:00 |  | 1147 | 23 | 41.5
2023-02-14 00:00:00 | Central | 406 |  | 8656 | 10:58:00 |  | 02:35:00 |  |  | 02:15:00 | 02:35:00 |  | 1249 | 23 | 41
2023-02-14 00:00:00 | [NAME] | [NAME] |  | 7778 | 01:00:00 |  | 21:20:00 |  |  | 21:05:00 | 21:20:00 |  | 181 | 4 | 35
2023-02-14 00:00:00 | F4L | 401(F4L) |  | 8623 | 03:03:00 |  | 10:30:00 |  |  | 21:55:00 | 22:30:00 |  | 784 | 15 | 42
2023-02-14 00:00:00 | Mariano's | M06 |  | 8643 | 05:29:00 |  | 23:05:00 | 23:38:00 |  | 22:30:00 | 23:05:00 |  | 1030 | 21 | 42
2023-02-14 00:00:00 | Mariano's | M07 |  | 8606 | 05:42:00 |  | 23:50:00 |  |  | 23:05:00 | 23:50:00 |  | 1131 | 26 | 42
2023-02-14 00:00:00 | Mariano's | M08 |  | 8616 | 05:44:00 |  | 00:25:00 |  |  | 23:50:00 | 00:25:00 |  | 1049 | 21 | 41.5