Spreadsheet: 801042d1666042112-sumifs-2-criterias-on-same-column-sumifs-2-criterias-on-same-column-alexxl-
Sheet: Sheet2

Time Interval | [NAME] name | Total calls | Talked to Agents | Closed in queue | [NAME] time | [NAME] time | [NAME] waiting time | Avg waiting time | Avg talk duration | Avg clerical duration | [NAME] | Answered<20s | Answered<30 s | Answered<60 s | Answered<90 s | Answered<120 s | Answered>=2 min | Closed in queue<10s | Closed in queue<20s | Closed in queue<30s | Closed in queue<60s | Closed in queue<90s | Closed in queue>=90s | Agent [NAME] | Agent Attempts>=10s | Dropped | Closed in IVR | Calls Not answered | Date
Day(MM-DD-YYYY) : 09-01-2022
09:00-10:00 | [NAME] cc | 1 | 1 | 0 | 00:00:32 | 00:00:32 | 00:00:00 | 00:00:00 | 00:12:40 | 00:00:02 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10:00-11:00 | [NAME] cc | 2 | 1 | 0 | 00:00:49 | 00:00:40 | 00:00:48 | 00:00:24 | 00:03:48 | 00:00:01 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
11:00-12:00 | [NAME] cc | 2 | 2 | 0 | 00:00:44 | 00:00:38 | 00:00:41 | 00:00:21 | 00:02:18 | 00:00:01 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12:00-13:00 | [NAME] cc | 3 | 3 | 0 | 00:00:32 | 00:00:32 | 00:00:00 | 00:00:00 | 00:03:37 | 00:00:01 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13:00-14:00 | [NAME] cc | 3 | 3 | 0 | 00:01:10 | 00:00:51 | 00:01:48 | 00:00:57 | 00:02:46 | 00:00:12 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14:00-15:00 | [NAME] cc | 7 | 6 | 0 | 00:01:24 | 00:00:43 | 00:02:18 | 00:00:39 | 00:04:12 | 00:00:01 | 4 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
15:00-16:00 | [NAME] cc | 5 | 2 | 2 | 00:01:59 | 00:00:56 | 00:03:52 | 00:01:32 | 00:22:17 | 00:00:07 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0
16:00-17:00 | [NAME] cc | 2 | 1 | 0 | 00:03:55 | 00:03:01 | 00:08:57 | 00:06:36 | 00:01:44 | 00:00:05 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
18:00-19:00 | [NAME] cc | 1 | 0 | 0 | 00:00:11 | 00:00:11 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
20:00-21:00 | [NAME] cc | 1 | 0 | 0 | 00:00:03 | 00:00:03 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
Day(MM-DD-YYYY) : 09-02-2022
09:00-10:00 | [NAME] cc | 1 | 1 | 0 | 00:00:32 | 00:00:32 | 00:00:00 | 00:00:00 | 00:12:40 | 00:00:02 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10:00-11:00 | [NAME] cc | 2 | 1 | 0 | 00:00:49 | 00:00:40 | 00:00:48 | 00:00:24 | 00:03:48 | 00:00:01 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
11:00-12:00 | [NAME] cc | 2 | 2 | 0 | 00:00:44 | 00:00:38 | 00:00:41 | 00:00:21 | 00:02:18 | 00:00:01 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12:00-13:00 | [NAME] cc | 3 | 3 | 0 | 00:00:32 | 00:00:32 | 00:00:00 | 00:00:00 | 00:03:37 | 00:00:01 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13:00-14:00 | [NAME] cc | 5 | 3 | 0 | 00:01:10 | 00:00:51 | 00:01:48 | 00:00:57 | 00:02:46 | 00:00:12 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14:00-15:00 | [NAME] cc | 7 | 6 | 0 | 00:01:24 | 00:00:43 | 00:02:18 | 00:00:39 | 00:04:12 | 00:00:01 | 4 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
15:00-16:00 | [NAME] cc | 5 | 2 | 2 | 00:01:59 | 00:00:56 | 00:03:52 | 00:01:32 | 00:22:17 | 00:00:07 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0
16:00-17:00 | [NAME] cc | 2 | 1 | 0 | 00:03:55 | 00:03:01 | 00:08:57 | 00:06:36 | 00:01:44 | 00:00:05 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
18:00-19:00 | [NAME] cc | 4 | 0 | 0 | 00:00:11 | 00:00:11 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
20:00-21:00 | [NAME] cc | 1 | 0 | 0 | 00:00:03 | 00:00:03 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0