Spreadsheet: 825962d1681694926-struggling-with-overnight-shift-info-on-gantt-baseline-chart-type-for-planning-purposes-overnight_dummydata-helpplease
Sheet: Backend

 | Start of Business | 00:00:00
 | Start of Week to review | 2023-04-17 00:00:00
 |  |  | Employee # | Days Off | Start of Shift | End of Shift | Date | Scheduled to work? |  | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00
 |  |  |  |  | 22:30:00 | 07:30:00
 |  |  | Employee 72 | Tue,Wed | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 72 | Tue,Wed | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 72 | Tue,Wed | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 72 | Tue,Wed | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 72 | Tue,Wed | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 72 | Tue,Wed | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 73 | Tue,Wed | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 73 | Tue,Wed | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 73 | Tue,Wed | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 73 | Tue,Wed | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 73 | Tue,Wed | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 73 | Tue,Wed | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 73 | Tue,Wed | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 74 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 74 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 74 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 74 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 74 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 74 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 74 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 75 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 75 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 75 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 75 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 75 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 75 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 75 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 76 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 76 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 76 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 76 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 76 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 76 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 76 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 77 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 77 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 77 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 77 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 77 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 77 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 77 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 78 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 78 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 78 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 78 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 78 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 78 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 78 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 79 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 79 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 79 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 79 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 79 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 79 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 79 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 80 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 80 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 80 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 80 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 80 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 80 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 80 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 81 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 81 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 81 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 81 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 81 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 81 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 81 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 82 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 82 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 82 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 82 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 82 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 82 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 82 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 83 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 83 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 83 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 83 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 83 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 83 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 83 | Fri,Sat | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 84 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 84 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 84 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 84 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 84 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 84 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 84 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 85 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 85 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 85 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 85 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 85 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 85 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 85 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 86 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 86 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 86 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 86 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 86 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 86 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 86 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 87 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 87 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 87 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 87 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 87 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 87 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 87 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 88 | Tue,Wed | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 88 | Tue,Wed | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 88 | Tue,Wed | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 88 | Tue,Wed | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 88 | Tue,Wed | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 88 | Tue,Wed | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 88 | Tue,Wed | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 89 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 89 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 89 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 89 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 89 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 89 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 89 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 90 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 90 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 90 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 90 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 90 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 90 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 90 | Mon,Tue | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 91 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 91 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 91 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 91 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 91 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 91 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 91 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 92 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 92 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 92 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 92 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 92 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 92 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 92 | Mon,Sun | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 93 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 93 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 93 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 93 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 93 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 93 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 93 | Sat,Sun | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00
 |  |  | Employee 71 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-17 00:00:00
 |  |  | Employee 71 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-18 00:00:00
 |  |  | Employee 71 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-19 00:00:00
 |  |  | Employee 71 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-20 00:00:00
 |  |  | Employee 71 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-21 00:00:00
 |  |  | Employee 71 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-22 00:00:00
 |  |  | Employee 71 | Thu,[NAME] | 22:30:00 | 07:30:00 | 2023-04-23 00:00:00