Spreadsheet: 861279d1709203291-need-formula-for-timesheet-staff-coverage-ans
Sheet: Dump

Name | Shift Date | Shift Start | Shift End | Comment
Agent 1 | 2024-02-26 00:00:00 | 09:00:00 | 17:30:00
Agent 2 | 2024-02-26 00:00:00 | 09:00:00 | 17:30:00
Agent 3 | 2024-02-26 00:00:00 | 10:30:00 | 19:00:00
Agent 4 | 2024-02-26 00:00:00 | 10:30:00 | 19:00:00
Agent 5 | 2024-02-26 00:00:00 | 09:00:00 | 17:30:00
Agent 6 | 2024-02-26 00:00:00 | 15:00:00 | 23:30:00
Agent 7 | 2024-02-26 00:00:00 | 11:30:00 | 20:30:00
Agent 8 | 2024-02-26 00:00:00 | 12:00:00 | 21:00:00
Agent 9 | 2024-02-26 00:00:00 | 12:00:00 | 21:00:00
Agent 10 | 2024-02-26 00:00:00 | 12:00:00 | 21:00:00
Agent 11 | 2024-02-26 00:00:00 | 12:00:00 | 21:00:00
Agent 12 | 2024-02-26 00:00:00 | 12:00:00 | 21:00:00
Agent 13 | 2024-02-26 00:00:00 | 12:00:00 | 21:00:00
Agent 14 | 2024-02-26 00:00:00 | 19:00:00 | 1900-01-01 03:00:00
Agent 15 | 2024-02-26 00:00:00 | 16:00:00 | 1900-01-01 00:00:00
Agent 16 | 2024-02-26 00:00:00 | 16:00:00 | 1900-01-01 00:00:00
Agent 1 | 2024-02-27 00:00:00 | 09:00:00 | 17:30:00
Agent 2 | 2024-02-27 00:00:00 | 09:00:00 | 17:30:00
Agent 3 | 2024-02-27 00:00:00 | 10:30:00 | 19:00:00
Agent 4 | 2024-02-27 00:00:00 | 10:30:00 | 19:00:00
Agent 5 | 2024-02-27 00:00:00 | 09:00:00 | 17:30:00
Agent 6 | 2024-02-27 00:00:00 | 15:00:00 | 23:30:00
Agent 7 | 2024-02-27 00:00:00 | 11:30:00 | 20:30:00
Agent 8 | 2024-02-27 00:00:00 | 12:00:00 | 21:00:00
Agent 9 | 2024-02-27 00:00:00 | 12:00:00 | 21:00:00
Agent 10 | 2024-02-27 00:00:00 | 12:00:00 | 21:00:00
Agent 11 | 2024-02-27 00:00:00 | 12:00:00 | 21:00:00
Agent 12 | 2024-02-27 00:00:00 | 12:00:00 | 21:00:00
Agent 13 | 2024-02-27 00:00:00 | 12:00:00 | 21:00:00
Agent 14 | 2024-02-27 00:00:00 | 19:00:00 | 1900-01-01 03:00:00
Agent 15 | 2024-02-27 00:00:00 | 16:00:00 | 1900-01-01 00:00:00
Agent 16 | 2024-02-27 00:00:00 | 16:00:00 | 1900-01-01 00:00:00
Agent 1 | 2024-02-28 00:00:00 | 09:00:00 | 17:30:00
Agent 2 | 2024-02-28 00:00:00 | 09:00:00 | 17:30:00
Agent 3 | 2024-02-28 00:00:00 | 10:30:00 | 19:00:00
Agent 4 | 2024-02-28 00:00:00 | 10:30:00 | 19:00:00
Agent 5 | 2024-02-28 00:00:00 | 09:00:00 | 17:30:00
Agent 6 | 2024-02-28 00:00:00 | 15:00:00 | 23:30:00
Agent 7 | 2024-02-28 00:00:00 | 11:30:00 | 20:30:00
Agent 8 | 2024-02-28 00:00:00 | 12:00:00 | 21:00:00
Agent 9 | 2024-02-28 00:00:00 | 12:00:00 | 21:00:00
Agent 10 | 2024-02-28 00:00:00 | 12:00:00 | 21:00:00
Agent 11 | 2024-02-28 00:00:00 | 12:00:00 | 21:00:00
Agent 12 | 2024-02-28 00:00:00 | 12:00:00 | 21:00:00
Agent 13 | 2024-02-28 00:00:00 | 12:00:00 | 21:00:00
Agent 14 | 2024-02-28 00:00:00 | 19:00:00 | 1900-01-01 03:00:00
Agent 15 | 2024-02-28 00:00:00 | 16:00:00 | 1900-01-01 00:00:00
Agent 16 | 2024-02-28 00:00:00 | 16:00:00 | 1900-01-01 00:00:00
Agent 1 | 2024-02-29 00:00:00
Agent 2 | 2024-02-29 00:00:00
Agent 3 | 2024-02-29 00:00:00
Agent 4 | 2024-02-29 00:00:00
Agent 5 | 2024-02-29 00:00:00
Agent 6 | 2024-02-29 00:00:00
Agent 7 | 2024-02-29 00:00:00
Agent 8 | 2024-02-29 00:00:00
Agent 9 | 2024-02-29 00:00:00
Agent 10 | 2024-02-29 00:00:00
Agent 11 | 2024-02-29 00:00:00
Agent 12 | 2024-02-29 00:00:00
Agent 13 | 2024-02-29 00:00:00
Agent 14 | 2024-02-29 00:00:00
Agent 15 | 2024-02-29 00:00:00
Agent 16 | 2024-02-29 00:00:00
Agent 1 | 2024-03-01 00:00:00
Agent 2 | 2024-03-01 00:00:00
Agent 3 | 2024-03-01 00:00:00
Agent 4 | 2024-03-01 00:00:00
Agent 5 | 2024-03-01 00:00:00
Agent 6 | 2024-03-01 00:00:00
Agent 7 | 2024-03-01 00:00:00
Agent 8 | 2024-03-01 00:00:00
Agent 9 | 2024-03-01 00:00:00
Agent 10 | 2024-03-01 00:00:00
Agent 11 | 2024-03-01 00:00:00
Agent 12 | 2024-03-01 00:00:00
Agent 13 | 2024-03-01 00:00:00
Agent 14 | 2024-03-01 00:00:00
Agent 15 | 2024-03-01 00:00:00
Agent 16 | 2024-03-01 00:00:00
Agent 1 | 2024-03-02 00:00:00
Agent 2 | 2024-03-02 00:00:00
Agent 3 | 2024-03-02 00:00:00
Agent 4 | 2024-03-02 00:00:00
Agent 5 | 2024-03-02 00:00:00
Agent 6 | 2024-03-02 00:00:00
Agent 7 | 2024-03-02 00:00:00
Agent 8 | 2024-03-02 00:00:00
Agent 9 | 2024-03-02 00:00:00
Agent 10 | 2024-03-02 00:00:00
Agent 11 | 2024-03-02 00:00:00
Agent 12 | 2024-03-02 00:00:00
Agent 13 | 2024-03-02 00:00:00
Agent 14 | 2024-03-02 00:00:00
Agent 15 | 2024-03-02 00:00:00
Agent 16 | 2024-03-02 00:00:00
Agent 1 | 2024-03-03 00:00:00
Agent 2 | 2024-03-03 00:00:00
Agent 3 | 2024-03-03 00:00:00
Agent 4 | 2024-03-03 00:00:00
Agent 5 | 2024-03-03 00:00:00
Agent 6 | 2024-03-03 00:00:00
Agent 7 | 2024-03-03 00:00:00
Agent 8 | 2024-03-03 00:00:00
Agent 9 | 2024-03-03 00:00:00
Agent 10 | 2024-03-03 00:00:00
Agent 11 | 2024-03-03 00:00:00
Agent 12 | 2024-03-03 00:00:00
Agent 13 | 2024-03-03 00:00:00
Agent 14 | 2024-03-03 00:00:00
Agent 15 | 2024-03-03 00:00:00
Agent 16 | 2024-03-03 00:00:00