Spreadsheet: 873433d1719932863-please-help-needed-scheduling-with-automatic-lunches-and-breaks-populated-test
Sheet: DeputyRosterWeekly_20240701_162

Employee | Start Date | Start Time | End Date | End Time | Total Meal Break | Total Time | Area | Break | Lunch | Break
 | 2024-07-01 00:00:00 | 08:30:00 | 2024-07-01 00:00:00 | 14:30:00 | 00:00:00 | 6 | POS
 | 2024-07-01 00:00:00 | 08:30:00 | 2024-07-01 00:00:00 | 17:00:00 | 00:30:00 | 8 | Leadership (Hourly)
 | 2024-07-01 00:00:00 | 08:45:00 | 2024-07-01 00:00:00 | 17:15:00 | 00:30:00 | 8 | Trainees
 | 2024-07-01 00:00:00 | 09:00:00 | 2024-07-01 00:00:00 | 15:00:00 | 00:00:00 | 6 | Lobby/Reception
 | 2024-07-01 00:00:00 | 09:00:00 | 2024-07-01 00:00:00 | 16:00:00 | 00:00:00 | 7 | Security
 | 2024-07-01 00:00:00 | 10:00:00 | 2024-07-01 00:00:00 | 18:30:00 | 00:30:00 | 8 | POS
 | 2024-07-01 00:00:00 | 10:00:00 | 2024-07-01 00:00:00 | 16:00:00 | 00:00:00 | 6 | Trainees
 | 2024-07-01 00:00:00 | 11:00:00 | 2024-07-01 00:00:00 | 19:30:00 | 00:30:00 | 8 | Leadership (Hourly)
 | 2024-07-01 00:00:00 | 11:30:00 | 2024-07-01 00:00:00 | 20:00:00 | 00:30:00 | 8 | Leadership (Salary)
 | 2024-07-01 00:00:00 | 11:30:00 | 2024-07-01 00:00:00 | 20:00:00 | 00:30:00 | 8 | POS
 | 2024-07-01 00:00:00 | 14:00:00 | 2024-07-01 00:00:00 | 20:00:00 | 00:00:00 | 6 | POS
 | 2024-07-01 00:00:00 | 14:00:00 | 2024-07-01 00:00:00 | 20:00:00 | 00:00:00 | 6 | Trainees
 | 2024-07-01 00:00:00 | 14:00:00 | 2024-07-01 00:00:00 | 20:00:00 | 00:00:00 | 6 | Trainees
 | 2024-07-01 00:00:00 | 14:00:00 | 2024-07-01 00:00:00 | 20:00:00 | 00:00:00 | 6 | POS
 | 2024-07-01 00:00:00 | 14:00:00 | 2024-07-01 00:00:00 | 20:00:00 | 00:00:00 | 6 | Trainees
 | 2024-07-01 00:00:00 | 16:00:00 | 2024-07-01 00:00:00 | 20:00:00 | 00:00:00 | 4 | Security
 | 2024-07-01 00:00:00 | 17:00:00 | 2024-07-01 00:00:00 | 20:00:00 | 00:00:00 | 3 | POS
 | 2024-07-02 00:00:00 | 08:30:00 | 2024-07-02 00:00:00 | 17:00:00 | 00:30:00 | 8 | Leadership (Salary)
 | 2024-07-02 00:00:00 | 08:30:00 | 2024-07-02 00:00:00 | 17:00:00 | 00:30:00 | 8 | POS
 | 2024-07-02 00:00:00 | 08:45:00 | 2024-07-02 00:00:00 | 17:15:00 | 00:30:00 | 8 | POS
 | 2024-07-02 00:00:00 | 09:00:00 | 2024-07-02 00:00:00 | 15:00:00 | 00:00:00 | 6 | Security
 | 2024-07-02 00:00:00 | 09:00:00 | 2024-07-02 00:00:00 | 15:00:00 | 00:00:00 | 6 | Lobby/Reception
 | 2024-07-02 00:00:00 | 09:00:00 | 2024-07-02 00:00:00 | 17:30:00 | 00:30:00 | 8 | POS
 | 2024-07-02 00:00:00 | 10:00:00 | 2024-07-02 00:00:00 | 18:30:00 | 00:30:00 | 8 | Leadership (Hourly)
 | 2024-07-02 00:00:00 | 11:00:00 | 2024-07-02 00:00:00 | 17:00:00 | 00:00:00 | 6 | Trainees
 | 2024-07-02 00:00:00 | 11:30:00 | 2024-07-02 00:00:00 | 20:00:00 | 00:30:00 | 8 | Leadership (Hourly)
 | 2024-07-02 00:00:00 | 11:30:00 | 2024-07-02 00:00:00 | 20:00:00 | 00:30:00 | 8 | Leadership (Hourly)
 | 2024-07-02 00:00:00 | 12:00:00 | 2024-07-02 00:00:00 | 18:00:00 | 00:00:00 | 6 | Trainees
 | 2024-07-02 00:00:00 | 12:30:00 | 2024-07-02 00:00:00 | 18:30:00 | 00:00:00 | 6 | POS
 | 2024-07-02 00:00:00 | 13:00:00 | 2024-07-02 00:00:00 | 19:00:00 | 00:00:00 | 6 | POS
 | 2024-07-02 00:00:00 | 13:00:00 | 2024-07-02 00:00:00 | 19:00:00 | 00:00:00 | 6 | Trainees
 | 2024-07-02 00:00:00 | 14:00:00 | 2024-07-02 00:00:00 | 20:00:00 | 00:00:00 | 6 | POS
 | 2024-07-02 00:00:00 | 14:00:00 | 2024-07-02 00:00:00 | 20:00:00 | 00:00:00 | 6 | Lobby/Reception
 | 2024-07-02 00:00:00 | 14:00:00 | 2024-07-02 00:00:00 | 20:00:00 | 00:00:00 | 6 | Trainees
 | 2024-07-02 00:00:00 | 15:00:00 | 2024-07-02 00:00:00 | 19:00:00 | 00:00:00 | 4 | Security
 | 2024-07-03 00:00:00 | 08:30:00 | 2024-07-03 00:00:00 | 17:00:00 | 00:30:00 | 8 | Leadership (Hourly)
 | 2024-07-03 00:00:00 | 08:30:00 | 2024-07-03 00:00:00 | 17:00:00 | 00:30:00 | 8 | Leadership (Salary)
 | 2024-07-03 00:00:00 | 08:45:00 | 2024-07-03 00:00:00 | 14:45:00 | 00:00:00 | 6 | POS
 | 2024-07-03 00:00:00 | 09:00:00 | 2024-07-03 00:00:00 | 15:00:00 | 00:00:00 | 6 | Lobby/Reception
 | 2024-07-03 00:00:00 | 09:00:00 | 2024-07-03 00:00:00 | 15:00:00 | 00:00:00 | 6 | Trainees
 | 2024-07-03 00:00:00 | 10:00:00 | 2024-07-03 00:00:00 | 18:30:00 | 00:30:00 | 8 | Leadership (Hourly)
 | 2024-07-03 00:00:00 | 11:00:00 | 2024-07-03 00:00:00 | 19:30:00 | 00:30:00 | 8 | Trainees
 | 2024-07-03 00:00:00 | 11:00:00 | 2024-07-03 00:00:00 | 17:00:00 | 00:00:00 | 6 | POS
 | 2024-07-03 00:00:00 | 11:30:00 | 2024-07-03 00:00:00 | 20:00:00 | 00:30:00 | 8 | POS
 | 2024-07-03 00:00:00 | 11:30:00 | 2024-07-03 00:00:00 | 20:00:00 | 00:30:00 | 8 | Leadership (Hourly)
 | 2024-07-03 00:00:00 | 13:00:00 | 2024-07-03 00:00:00 | 19:00:00 | 00:00:00 | 6 | Security
 | 2024-07-03 00:00:00 | 13:00:00 | 2024-07-03 00:00:00 | 19:00:00 | 00:00:00 | 6 | Trainees
 | 2024-07-03 00:00:00 | 13:00:00 | 2024-07-03 00:00:00 | 19:00:00 | 00:00:00 | 6 | POS
 | 2024-07-03 00:00:00 | 14:00:00 | 2024-07-03 00:00:00 | 20:00:00 | 00:00:00 | 6 | POS
 | 2024-07-03 00:00:00 | 14:00:00 | 2024-07-03 00:00:00 | 20:00:00 | 00:00:00 | 6 | Lobby/Reception
 | 2024-07-03 00:00:00 | 14:00:00 | 2024-07-03 00:00:00 | 20:00:00 | 00:00:00 | 6 | POS
 | 2024-07-03 00:00:00 | 14:00:00 | 2024-07-03 00:00:00 | 20:00:00 | 00:00:00 | 6 | Trainees
 | 2024-07-04 00:00:00 | 08:30:00 | 2024-07-04 00:00:00 | 17:00:00 | 00:30:00 | 8 | Leadership (Salary)
 | 2024-07-04 00:00:00 | 08:30:00 | 2024-07-04 00:00:00 | 17:00:00 | 00:30:00 | 8 | Leadership (Hourly)
 | 2024-07-04 00:00:00 | 08:45:00 | 2024-07-04 00:00:00 | 14:45:00 | 00:00:00 | 6 | POS
 | 2024-07-04 00:00:00 | 08:45:00 | 2024-07-04 00:00:00 | 17:15:00 | 00:30:00 | 8 | POS
 | 2024-07-04 00:00:00 | 09:00:00 | 2024-07-04 00:00:00 | 19:00:00 | 00:00:00 | 10 | Security
 | 2024-07-04 00:00:00 | 09:00:00 | 2024-07-04 00:00:00 | 15:00:00 | 00:00:00 | 6 | Lobby/Reception
 | 2024-07-04 00:00:00 | 11:00:00 | 2024-07-04 00:00:00 | 19:30:00 | 00:30:00 | 8 | Leadership (Salary)
 | 2024-07-04 00:00:00 | 11:00:00 | 2024-07-04 00:00:00 | 17:00:00 | 00:00:00 | 6 | POS
 | 2024-07-04 00:00:00 | 11:00:00 | 2024-07-04 00:00:00 | 17:00:00 | 00:00:00 | 6 | Trainees
 | 2024-07-04 00:00:00 | 13:00:00 | 2024-07-04 00:00:00 | 19:00:00 | 00:00:00 | 6 | POS
 | 2024-07-04 00:00:00 | 14:00:00 | 2024-07-04 00:00:00 | 20:00:00 | 00:00:00 | 6 | Trainees
 | 2024-07-04 00:00:00 | 14:00:00 | 2024-07-04 00:00:00 | 22:30:00 | 00:30:00 | 8 | Trainees
 | 2024-07-04 00:00:00 | 14:00:00 | 2024-07-04 00:00:00 | 22:30:00 | 00:30:00 | 8 | Leadership (Hourly)
 | 2024-07-04 00:00:00 | 14:00:00 | 2024-07-04 00:00:00 | 22:30:00 | 00:30:00 | 8 | Leadership (Hourly)
 | 2024-07-04 00:00:00 | 15:00:00 | 2024-07-04 00:00:00 | 21:00:00 | 00:00:00 | 6 | POS
 | 2024-07-04 00:00:00 | 15:00:00 | 2024-07-04 00:00:00 | 21:00:00 | 00:00:00 | 6 | Lobby/Reception
 | 2024-07-04 00:00:00 | 16:30:00 | 2024-07-04 00:00:00 | 22:30:00 | 00:00:00 | 6 | POS
 | 2024-07-04 00:00:00 | 17:00:00 | 2024-07-04 00:00:00 | 22:30:00 | 00:00:00 | 5.5 | POS
 | 2024-07-05 00:00:00 | 08:30:00 | 2024-07-05 00:00:00 | 17:00:00 | 00:30:00 | 8 | Leadership (Salary)
 | 2024-07-05 00:00:00 | 08:45:00 | 2024-07-05 00:00:00 | 14:45:00 | 00:00:00 | 6 | POS
 | 2024-07-05 00:00:00 | 08:45:00 | 2024-07-05 00:00:00 | 14:45:00 | 00:00:00 | 6 | POS
 | 2024-07-05 00:00:00 | 09:00:00 | 2024-07-05 00:00:00 | 16:00:00 | 00:00:00 | 7 | Security
 | 2024-07-05 00:00:00 | 09:00:00 | 2024-07-05 00:00:00 | 15:00:00 | 00:00:00 | 6 | Lobby/Reception
 | 2024-07-05 00:00:00 | 10:00:00 | 2024-07-05 00:00:00 | 18:30:00 | 00:30:00 | 8 | POS
 | 2024-07-05 00:00:00 | 10:00:00 | 2024-07-05 00:00:00 | 18:30:00 | 00:30:00 | 8 | Leadership (Hourly)
 | 2024-07-05 00:00:00 | 11:00:00 | 2024-07-05 00:00:00 | 19:30:00 | 00:30:00 | 8 | Leadership (Hourly)
 | 2024-07-05 00:00:00 | 11:00:00 | 2024-07-05 00:00:00 | 19:30:00 | 00:30:00 | 8 | Trainees
 | 2024-07-05 00:00:00 | 13:00:00 | 2024-07-05 00:00:00 | 19:00:00 | 00:00:00 | 6 | POS
 | 2024-07-05 00:00:00 | 14:00:00 | 2024-07-05 00:00:00 | 22:30:00 | 00:30:00 | 8 | Leadership (Salary)
 | 2024-07-05 00:00:00 | 14:00:00 | 2024-07-05 00:00:00 | 22:30:00 | 00:30:00 | 8 | Leadership (Hourly)
 | 2024-07-05 00:00:00 | 14:00:00 | 2024-07-05 00:00:00 | 22:30:00 | 00:30:00 | 8 | POS
 | 2024-07-05 00:00:00 | 14:00:00 | 2024-07-05 00:00:00 | 22:30:00 | 00:30:00 | 8 | POS
 | 2024-07-05 00:00:00 | 15:00:00 | 2024-07-05 00:00:00 | 21:00:00 | 00:00:00 | 6 | Trainees
 | 2024-07-05 00:00:00 | 15:00:00 | 2024-07-05 00:00:00 | 21:00:00 | 00:00:00 | 6 | POS
 | 2024-07-05 00:00:00 | 15:00:00 | 2024-07-05 00:00:00 | 21:00:00 | 00:00:00 | 6 | Trainees
 | 2024-07-05 00:00:00 | 16:00:00 | 2024-07-05 00:00:00 | 21:00:00 | 00:00:00 | 5 | Security
 | 2024-07-05 00:00:00 | 16:30:00 | 2024-07-05 00:00:00 | 22:30:00 | 00:00:00 | 6 | Trainees
 | 2024-07-05 00:00:00 | 16:30:00 | 2024-07-05 00:00:00 | 22:30:00 | 00:00:00 | 6 | POS
 | 2024-07-06 00:00:00 | 08:30:00 | 2024-07-06 00:00:00 | 17:00:00 | 00:30:00 | 8 | Leadership (Hourly)
 | 2024-07-06 00:00:00 | 08:45:00 | 2024-07-06 00:00:00 | 17:15:00 | 00:30:00 | 8 | POS
 | 2024-07-06 00:00:00 | 08:45:00 | 2024-07-06 00:00:00 | 14:45:00 | 00:00:00 | 6 | POS
 | 2024-07-06 00:00:00 | 08:45:00 | 2024-07-06 00:00:00 | 12:45:00 | 00:00:00 | 4 | POS
 | 2024-07-06 00:00:00 | 09:00:00 | 2024-07-06 00:00:00 | 15:00:00 | 00:00:00 | 6 | Lobby/Reception
 | 2024-07-06 00:00:00 | 10:00:00 | 2024-07-06 00:00:00 | 18:30:00 | 00:30:00 | 8 | Leadership (Salary)
 | 2024-07-06 00:00:00 | 10:00:00 | 2024-07-06 00:00:00 | 18:30:00 | 00:30:00 | 8 | Trainees
 | 2024-07-06 00:00:00 | 10:00:00 | 2024-07-06 00:00:00 | 18:30:00 | 00:30:00 | 8 | POS
 | 2024-07-06 00:00:00 | 11:00:00 | 2024-07-06 00:00:00 | 19:30:00 | 00:30:00 | 8 | Leadership (Hourly)
 | 2024-07-06 00:00:00 | 11:00:00 | 2024-07-06 00:00:00 | 17:00:00 | 00:00:00 | 6 | POS
 | 2024-07-06 00:00:00 | 12:30:00 | 2024-07-06 00:00:00 | 21:00:00 | 00:30:00 | 8 | POS
 | 2024-07-06 00:00:00 | 13:00:00 | 2024-07-06 00:00:00 | 19:00:00 | 00:00:00 | 6 | Trainees
 | 2024-07-06 00:00:00 | 14:00:00 | 2024-07-06 00:00:00 | 22:30:00 | 00:30:00 | 8 | Leadership (Hourly)
 | 2024-07-06 00:00:00 | 14:00:00 | 2024-07-06 00:00:00 | 22:30:00 | 00:30:00 | 8 | Leadership (Hourly)
 | 2024-07-06 00:00:00 | 14:00:00 | 2024-07-06 00:00:00 | 21:00:00 | 00:00:00 | 7 | Security
 | 2024-07-06 00:00:00 | 14:00:00 | 2024-07-06 00:00:00 | 20:00:00 | 00:00:00 | 6 | POS
 | 2024-07-06 00:00:00 | 15:00:00 | 2024-07-06 00:00:00 | 21:00:00 | 00:00:00 | 6 | Lobby/Reception
 | 2024-07-06 00:00:00 | 16:00:00 | 2024-07-06 00:00:00 | 22:30:00 | 00:30:00 | 6 | POS
 | 2024-07-06 00:00:00 | 16:30:00 | 2024-07-06 00:00:00 | 22:30:00 | 00:00:00 | 6 | POS
 | 2024-07-06 00:00:00 | 16:30:00 | 2024-07-06 00:00:00 | 22:30:00 | 00:00:00 | 6 | Trainees
 | 2024-07-07 00:00:00 | 08:30:00 | 2024-07-07 00:00:00 | 17:00:00 | 00:30:00 | 8 | Leadership (Salary)
 | 2024-07-07 00:00:00 | 08:45:00 | 2024-07-07 00:00:00 | 17:15:00 | 00:30:00 | 8 | POS
 | 2024-07-07 00:00:00 | 09:00:00 | 2024-07-07 00:00:00 | 15:00:00 | 00:00:00 | 6 | Security
 | 2024-07-07 00:00:00 | 09:00:00 | 2024-07-07 00:00:00 | 15:00:00 | 00:00:00 | 6 | Lobby/Reception
 | 2024-07-07 00:00:00 | 10:00:00 | 2024-07-07 00:00:00 | 16:00:00 | 00:00:00 | 6 | POS
 | 2024-07-07 00:00:00 | 10:00:00 | 2024-07-07 00:00:00 | 18:30:00 | 00:30:00 | 8 | Leadership (Hourly)
 | 2024-07-07 00:00:00 | 11:00:00 | 2024-07-07 00:00:00 | 19:30:00 | 00:30:00 | 8 | POS
 | 2024-07-07 00:00:00 | 11:00:00 | 2024-07-07 00:00:00 | 19:30:00 | 00:30:00 | 8 | Leadership (Hourly)
 | 2024-07-07 00:00:00 | 12:30:00 | 2024-07-07 00:00:00 | 21:00:00 | 00:30:00 | 8 | POS
 | 2024-07-07 00:00:00 | 13:00:00 | 2024-07-07 00:00:00 | 19:00:00 | 00:00:00 | 6 | Trainees
 | 2024-07-07 00:00:00 | 14:00:00 | 2024-07-07 00:00:00 | 22:30:00 | 00:30:00 | 8 | Leadership (Salary)
 | 2024-07-07 00:00:00 | 14:00:00 | 2024-07-07 00:00:00 | 22:30:00 | 00:30:00 | 8 | POS
 | 2024-07-07 00:00:00 | 15:00:00 | 2024-07-07 00:00:00 | 21:00:00 | 00:00:00 | 6 | POS
 | 2024-07-07 00:00:00 | 15:00:00 | 2024-07-07 00:00:00 | 21:00:00 | 00:00:00 | 6 | Lobby/Reception
 | 2024-07-07 00:00:00 | 16:30:00 | 2024-07-07 00:00:00 | 22:30:00 | 00:00:00 | 6 | POS