Spreadsheet: 816220d1675432624-gantt-chart-not-calculating-anymore-excel-help
Sheet: Monday WORKLOAD

 | Reg |  | Arr |  | Dep |  | Check acc CSM | System | Hours req'd |  |  | [NAME] | 05:30:00 | 05:45:00 | 06:00:00 | 06:15:00 | 06:30:00 | 06:45:00 | 07:00:00 | 07:15:00 | 07:30:00 | 07:45:00 | 08:00:00 | 08:15:00 | 08:30:00 | 08:45:00 | 09:00:00 | 09:15:00 | 09:30:00 | 09:45:00 | 10:00:00 | 10:15:00 | 10:30:00 | 10:45:00 | 11:00:00 | 11:15:00 | 11:30:00 | 11:45:00 | 12:00:00 | 12:15:00 | 12:30:00 | 12:45:00 | 13:00:00 | 13:15:00 | 13:30:00 | 13:45:00 | 14:00:00 | 14:15:00 | 14:30:00 | 14:45:00 | 15:00:00 | 15:15:00 | 15:30:00 | 15:45:00 | 16:00:00 | 16:15:00 | 16:30:00 | 16:45:00 | 17:00:00 | 17:15:00 | 17:30:00 | 17:45:00 | 18:00:00 | 18:15:00 | 18:30:00 | 18:45:00 | 19:00:00 | 19:15:00 | 19:30:00 | 19:45:00 | 20:00:00 | 20:15:00 | 20:30:00 | 20:45:00 | 21:00:00 | 21:15:00 | 21:30:00 | 21:45:00 | 22:00:00 | 22:15:00 | 22:30:00 | 22:45:00 | 23:00:00 | 23:15:00 | 23:30:00 | 23:45:00 | 1900-01-01 00:00:00 | 1900-01-01 00:15:00 | 1900-01-01 00:30:00
 |  |  | 10:00:00 |  | 08:30 |  |  |  |  | 10:00 |  | 05:35:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15
 |  |  | 10:00:00 |  | 12:00 |  |  |  |  | 10:00 |  | 05:40:00 |  |  |  | 15
 |  |  | 05:30:00 |  | 23:59 |  |  |  |  | 10:00 |  | 05:55:00 |  |  | 15 | 15 | 15
 |  |  | 05:00:00 |  | 13:05 |  |  |  |  | 10:00 |  | 05:55:00 |  |  | 15 | 15 | 15 | 15
 |  |  | 10:00:00 |  | 11:10 |  |  |  |  | 10:00 |  | 05:55:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  | 11:00:00 |  | 12:55 |  |  |  |  | 11:00 |  |  |  |  |  |  |  |  | 15 | 15 | 15
 |  |  | 11:00:00 |  | 10:40 |  |  |  |  | 11:00 |  | 05:55:00 |  |  |  |  |  |  |  | 15 | 15 | 15
 |  |  | 18:00:00 |  | 12:35 |  |  |  |  | 18:00 |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  | 18:00:00 |  | 09:00 |  |  |  |  | 18:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  | 09:55:00 |  | 12:55 |  |  |  |  | 09:55 |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  | 12:45:00 |  | 09:45 |  |  |  |  | 12:45 |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15 | 15
 |  |  | 06:00:00 |  | 10:45 |  |  |  |  | 06:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15
 |  |  | 11:05:00 |  | 10:00 |  |  |  |  | 11:05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15
 |  |  | 07:35:00 |  | 21:15 |  |  |  |  | 07:35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15
 |  |  | 07:50:00 |  | 09:50 |  |  |  |  | 07:50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15
 |  |  | 05:30:00 |  | 11:00 |  |  |  |  | 05:30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15 | 15
 |  |  | 10:35:00 |  | 15:20 |  |  |  |  | 10:35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15 | 15
 |  |  | 00:01:00 |  | 10:10 |  |  |  |  | 00:01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15
 |  |  | 18:05:00 |  | 09:50 |  |  |  |  | 18:05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  | 09:45:00 |  | 10:35 |  |  |  |  | 09:45 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15
 |  |  |  |  |  |  |  |  |  | 15:05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15
 |  |  |  |  |  |  |  |  |  | 11:55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15 | 15
 |  |  |  |  |  |  |  |  |  | 06:20
 |  |  |  |  |  |  |  |  |  | 07:15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  | 12:20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15 | 15
 |  |  |  |  |  |  |  |  |  | 10:35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15 | 15
 |  |  |  |  |  |  |  |  |  | 06:50
 |  |  |  |  |  |  |  |  |  | 08:20
 |  |  |  |  |  |  |  |  |  | 10:50
 |  |  |  |  |  |  |  |  |  | 12:25
 |  |  |  |  |  |  |  |  |  | 00:01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  | 14:15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15
 |  |  |  |  |  |  |  |  |  | 13:20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15
 |  |  |  |  |  |  |  |  |  | 06:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  | 11:20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15
 |  |  |  |  |  |  |  |  |  | 09:15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15
 |  |  |  |  |  |  |  |  |  | 08:15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15
 |  |  |  |  |  |  |  |  |  | 08:35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15 |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  | 05:55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15
 |  |  |  |  |  |  |  |  |  | 19:15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  | 06:25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  | 11:40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  | 06:35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15 | 15
 |  |  |  |  |  |  |  |  |  | 05:50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  | 07:10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  | 10:55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15
 |  |  |  |  |  |  |  |  |  | 10:15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15
 |  |  |  |  |  |  |  |  |  | 15:25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  | 11:50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15
 |  |  |  |  |  |  |  |  |  | 05:30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15
 |  |  |  |  |  |  |  |  |  | 09:05
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | 06:00:00 |  |  |  | 07:00:00 |  |  |  | 08:00:00 |  |  |  | 09:00:00 |  |  |  | 10:00:00 |  |  |  | 11:00:00 |  |  |  | 12:00:00 |  |  |  | 13:00:00 |  |  |  | 14:00:00 |  |  |  | 15:00:00 |  |  |  | 16:00:00 |  |  |  | 17:00:00 |  |  |  | 18:00:00 |  |  |  | 19:00:00 |  |  |  | 20:00:00 |  |  |  | 21:00:00 |  |  |  | 22:00:00 |  |  |  | 23:00:00 |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  | 25