Spreadsheet: 861271d1709198797-need-formula-for-timesheet-staff-coverage
Sheet: 2.26 - 3.3.2024

2024-02-26 00:00:00
Time |  | 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 |  |  |  | 1900-01-01 01:00:00 |  |  |  | 1900-01-01 02:00:00 |  |  |  | 1900-01-01 03:00:00 |  |  |  | 1900-01-01 04:00:00 |  |  |  | 1900-01-01 05:00:00 |  |  |  | Total Shift Hour per Individual
 |  | 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 | 1900-01-01 00:45:00 | 1900-01-01 01:00:00 | 1900-01-01 01:15:00 | 1900-01-01 01:30:00 | 1900-01-01 01:45:00 | 1900-01-01 02:00:00 | 1900-01-01 02:15:00 | 1900-01-01 02:30:00 | 1900-01-01 02:45:00 | 1900-01-01 03:00:00 | 1900-01-01 03:15:00 | 1900-01-01 03:30:00 | 1900-01-01 03:45:00 | 1900-01-01 04:00:00 | 1900-01-01 04:15:00 | 1900-01-01 04:30:00 | 1900-01-01 04:45:00 | 1900-01-01 05:00:00 | 1900-01-01 05:15:00 | 1900-01-01 05:30:00 | 1900-01-01 05:45:00
Office 1
Agent 1 | 2024-02-26 00:00:00
Agent 2 | 2024-02-26 00:00:00
Agent 3 | 2024-02-26 00:00:00
Agent 4 | 2024-02-26 00:00:00
Agent 5 | 2024-02-26 00:00:00
Agent 6 | 2024-02-26 00:00:00
Office 2
Agent 7 | 2024-02-26 00:00:00
Agent 8 | 2024-02-26 00:00:00
Agent 9 | 2024-02-26 00:00:00
Agent 10 | 2024-02-26 00:00:00
Agent 11 | 2024-02-26 00:00:00
Agent 12 | 2024-02-26 00:00:00
Agent 13 | 2024-02-26 00:00:00
Office 3
Agent 14 | 2024-02-26 00:00:00
Agent 15 | 2024-02-26 00:00:00
Agent 16 | 2024-02-26 00:00:00
Total Online: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total
SYD Time |  | 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 |  |  |  | 1900-01-01 01:00:00 |  |  |  | 1900-01-01 02:00:00 |  |  |  | 1900-01-01 03:00:00 |  |  |  | 1900-01-01 04:00:00 |  |  |  | 1900-01-01 05:00: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 | 1900-01-01 00:45:00 | 1900-01-01 01:00:00 | 1900-01-01 01:15:00 | 1900-01-01 01:30:00 | 1900-01-01 01:45:00 | 1900-01-01 02:00:00 | 1900-01-01 02:15:00 | 1900-01-01 02:30:00 | 1900-01-01 02:45:00 | 1900-01-01 03:00:00 | 1900-01-01 03:15:00 | 1900-01-01 03:30:00 | 1900-01-01 03:45:00 | 1900-01-01 04:00:00 | 1900-01-01 04:15:00 | 1900-01-01 04:30:00 | 1900-01-01 04:45:00 | 1900-01-01 05:00:00 | 1900-01-01 05:15:00 | 1900-01-01 05:30:00 | 1900-01-01 05:45:00
Office 1
Agent 1 | 2024-02-27 00:00:00
Agent 2 | 2024-02-27 00:00:00
Agent 3 | 2024-02-27 00:00:00
Agent 4 | 2024-02-27 00:00:00
Agent 5 | 2024-02-27 00:00:00
Agent 6 | 2024-02-27 00:00:00
Office 2
Agent 7 | 2024-02-27 00:00:00
Agent 8 | 2024-02-27 00:00:00
Agent 9 | 2024-02-27 00:00:00
Agent 10 | 2024-02-27 00:00:00
Agent 11 | 2024-02-27 00:00:00
Agent 12 | 2024-02-27 00:00:00
Agent 13 | 2024-02-27 00:00:00
Office 3
Agent 14 | 2024-02-27 00:00:00
Agent 15 | 2024-02-27 00:00:00
Agent 16 | 2024-02-27 00:00:00
Total Online: