Spreadsheet: 872148d1718528284-issue-with-sumifs-for-30-minutes-interval-agent
Sheet: Shifts Exercise

 | 1- Agent Staffing by Start Time
 | Shift time | Shift end | Agent count | Break time |  |  | Row Labels | Sum of Agent count
 | 07:59:59.997000 | 16:59:59.997000 |  |  |  |  | 8 AM | 9
 | 08:30:00.003000 | 17:30:00.003000 |  |  |  |  | 9 AM | 8
 | 09:00:00 | 18:00:00 |  |  |  |  | 10 AM | 28
 | 09:29:59.997000 | 18:29:59.997000 |  |  |  |  | 11 AM | 13
 | 10:00:00.003000 | 19:00:00.003000 |  |  |  |  | 12 PM | 4
 | 10:30:00 | 19:30:00 |  |  |  |  | 1 PM | 12
 | 10:59:59.997000 | 19:59:59.997000 |  |  |  |  | 2 PM | 6
 | 11:30:00.003000 | 20:30:00.003000 |  |  |  |  | 3 PM | 21
 | 12:00:00 | 21:00:00 |  |  |  |  | 5 PM | 1
 | 12:29:59.997000 | 21:29:59.997000 |  |  |  |  | 6 PM | 45
 | 13:30:00 | 22:30:00 |  |  |  |  | 7 PM | 12
 | 13:59:59.997000 | 22:59:59.997000 |  |  |  |  | 8 PM | 42
 | 14:30:00.003000 | 23:30:00.003000 |  |  |  |  | 11 PM | 18
 | 15:00:00 | 1900-01-01 00:00:00 |  |  |  |  | Grand Total | 219
 | 16:59:59.997000 | 1900-01-01 01:59:59.997000
 | 18:00:00 | 1900-01-01 03:00:00
 | 18:29:59.997000 | 1900-01-01 03:29:59.997000
 | 19:00:00.003000 | 1900-01-01 04:00:00.003000
 | 19:30:00 | 1900-01-01 04:30:00
 | 19:59:59.997000 | 1900-01-01 05:00:00
 | 22:59:59.997000 | 1900-01-01 07:59:59.997000
 | 2- Intraday Agent Coverage
 | Start time | End time | Agent count including break | Agent count after break
 | 1900-01-01 00:00:00 | 1900-01-01 00:30:00
 | 1900-01-01 00:30:00 | 1900-01-01 01:00:00
 | 1900-01-01 01:00:00 | 1900-01-01 01:30:00
 | 1900-01-01 01:30:00 | 1900-01-01 02:00:00
 | 1900-01-01 02:00:00 | 1900-01-01 02:30:00
 | 1900-01-01 02:30:00 | 1900-01-01 03:00:00
 | 1900-01-01 03:00:00 | 1900-01-01 03:30:00
 | 1900-01-01 03:30:00 | 1900-01-01 04:00:00
 | 1900-01-01 04:00:00 | 1900-01-01 04:30:00
 | 1900-01-01 04:30:00 | 1900-01-01 05:00:00
 | 1900-01-01 05:00:00 | 1900-01-01 05:30:00
 | 1900-01-01 05:30:00 | 1900-01-01 06:00:00
 | 1900-01-01 06:00:00 | 1900-01-01 06:30:00
 | 1900-01-01 06:30:00 | 1900-01-01 07:00:00
 | 1900-01-01 07:00:00 | 1900-01-01 07:30:00
 | 1900-01-01 07:30:00 | 1900-01-01 08:00:00
 | 1900-01-01 08:00:00 | 1900-01-01 08:30:00
 | 1900-01-01 08:30:00 | 1900-01-01 09:00:00
 | 1900-01-01 09:00:00 | 1900-01-01 09:30:00
 | 1900-01-01 09:30:00 | 1900-01-01 10:00:00
 | 1900-01-01 10:00:00 | 1900-01-01 10:30:00
 | 1900-01-01 10:30:00 | 1900-01-01 11:00:00
 | 1900-01-01 11:00:00 | 1900-01-01 11:30:00
 | 1900-01-01 11:30:00 | 1900-01-01 12:00:00
 | 1900-01-01 12:00:00 | 1900-01-01 12:30:00
 | 1900-01-01 12:30:00 | 1900-01-01 13:00:00
 | 1900-01-01 13:00:00 | 1900-01-01 13:30:00
 | 1900-01-01 13:30:00 | 1900-01-01 14:00:00
 | 1900-01-01 14:00:00 | 1900-01-01 14:30:00
 | 1900-01-01 14:30:00 | 1900-01-01 15:00:00
 | 1900-01-01 15:00:00 | 1900-01-01 15:30:00
 | 1900-01-01 15:30:00 | 1900-01-01 16:00:00
 | 1900-01-01 16:00:00 | 1900-01-01 16:30:00
 | 1900-01-01 16:30:00 | 1900-01-01 17:00:00
 | 1900-01-01 17:00:00 | 1900-01-01 17:30:00
 | 1900-01-01 17:30:00 | 1900-01-01 18:00:00
 | 1900-01-01 18:00:00 | 1900-01-01 18:30:00
 | 1900-01-01 18:30:00 | 1900-01-01 19:00:00
 | 1900-01-01 19:00:00 | 1900-01-01 19:30:00
 | 1900-01-01 19:30:00 | 1900-01-01 20:00:00
 | 1900-01-01 20:00:00 | 1900-01-01 20:30:00
 | 1900-01-01 20:30:00 | 1900-01-01 21:00:00
 | 1900-01-01 21:00:00 | 1900-01-01 21:30:00
 | 1900-01-01 21:30:00 | 1900-01-01 22:00:00
 | 1900-01-01 22:00:00 | 1900-01-01 22:30:00
 | 1900-01-01 22:30:00 | 1900-01-01 23:00:00
 | 1900-01-01 23:00:00 | 1900-01-01 23:30:00
 | 1900-01-01 23:30:00 | 1900-01-02 00:00:00