Spreadsheet: 725993d1617011725-counting-the-occurrences-between-two-times-hh-mm-on-a-specific-date-example-of-working-excel-book
Sheet: wc 08-03

Date | Time | Used |  |  |  | Overview | Date | No Of Calls | Total Duration | Average call duration
2021-03-08 00:00:00 | 11:31:00 | 00:01:01 |  |  |  |  | 2021-03-08 00:00:00
2021-03-08 00:00:00 | 11:37:00 | 00:00:50 |  |  |  |  | 2021-03-09 00:00:00
2021-03-08 00:00:00 | 11:39:00 | 00:01:06 |  |  |  |  | 2021-03-10 00:00:00
2021-03-08 00:00:00 | 11:41:00 | 00:00:57 |  |  |  |  | 2021-03-11 00:00:00
2021-03-08 00:00:00 | 15:40:00 | 00:02:10 |  |  |  |  | 2021-03-12 00:00:00 |  |  | 00:00:00
2021-03-08 00:00:00 | 15:47:00 | 00:00:26 |  |  |  |  | Totals
2021-03-08 00:00:00 | 15:48:00 | 00:01:39
2021-03-08 00:00:00 | 15:55:00 | 00:01:36
2021-03-08 00:00:00 | 16:00:00 | 00:01:13 |  |  |  |  | Date of call | Total No of Calls | Time of call
2021-03-08 00:00:00 | 16:03:00 | 00:01:17 |  |  |  |  | Start |  | 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
2021-03-08 00:00:00 | 16:03:00 | 00:00:01 |  |  |  |  | End |  | 09:59:00 | 10:59:00 | 11:59:00 | 12:59:00 | 13:59:00 | 14:59:00 | 15:59:00 | 16:59:00 | 17:59:00
2021-03-08 00:00:00 | 16:06:00 | 00:00:02 |  |  |  | No of calls made during specific time | 2021-03-08 00:00:00
2021-03-08 00:00:00 | 16:09:00 | 00:00:59 |  |  |  |  | 2021-03-09 00:00:00
2021-03-08 00:00:00 | 16:26:00 | 00:00:16 |  |  |  |  | 2021-03-10 00:00:00
2021-03-09 00:00:00 | 11:34:00 | 00:01:08 |  |  |  |  | 2021-03-11 00:00:00
2021-03-09 00:00:00 | 11:36:00 | 00:00:45 |  |  |  |  | 2021-03-12 00:00:00
2021-03-09 00:00:00 | 11:42:00 | 00:00:48 |  |  |  |  | Weekly Total
2021-03-09 00:00:00 | 11:45:00 | 00:01:19
2021-03-09 00:00:00 | 11:50:00 | 00:01:03
2021-03-09 00:00:00 | 11:53:00 | 00:00:58
2021-03-09 00:00:00 | 11:59:00 | 00:01:06
2021-03-09 00:00:00 | 12:01:00 | 00:00:40
2021-03-09 00:00:00 | 12:04:00 | 00:00:52
2021-03-09 00:00:00 | 12:06:00 | 00:00:25
2021-03-09 00:00:00 | 12:08:00 | 00:01:04
2021-03-09 00:00:00 | 12:10:00 | 00:00:25
2021-03-09 00:00:00 | 12:12:00 | 00:00:45
2021-03-09 00:00:00 | 12:29:00 | 00:00:39
2021-03-09 00:00:00 | 12:31:00 | 00:00:46
2021-03-09 00:00:00 | 15:00:00 | 00:01:01
2021-03-09 00:00:00 | 15:02:00 | 00:00:35
2021-03-09 00:00:00 | 15:38:00 | 00:00:44
2021-03-09 00:00:00 | 15:41:00 | 00:00:52
2021-03-09 00:00:00 | 15:46:00 | 00:01:27
2021-03-09 00:00:00 | 15:49:00 | 00:00:12
2021-03-09 00:00:00 | 15:50:00 | 00:02:05
2021-03-09 00:00:00 | 15:53:00 | 00:00:33
2021-03-09 00:00:00 | 15:56:00 | 00:01:05
2021-03-09 00:00:00 | 15:59:00 | 00:00:22
2021-03-09 00:00:00 | 16:01:00 | 00:00:30
2021-03-09 00:00:00 | 16:02:00 | 00:00:50
2021-03-09 00:00:00 | 16:04:00 | 00:00:39
2021-03-09 00:00:00 | 16:06:00 | 00:00:57
2021-03-09 00:00:00 | 16:10:00 | 00:00:27
2021-03-09 00:00:00 | 16:17:00 | 00:00:24
2021-03-09 00:00:00 | 16:19:00 | 00:00:43
2021-03-09 00:00:00 | 16:21:00 | 00:01:13
2021-03-09 00:00:00 | 16:37:00 | 00:00:34
2021-03-10 00:00:00 | 11:41:00 | 00:00:48
2021-03-10 00:00:00 | 11:42:00 | 00:00:42
2021-03-10 00:00:00 | 11:44:00 | 00:01:20
2021-03-10 00:00:00 | 11:46:00 | 00:00:25
2021-03-10 00:00:00 | 11:47:00 | 00:00:33
2021-03-10 00:00:00 | 11:53:00 | 00:00:06
2021-03-10 00:00:00 | 11:54:00 | 00:00:47
2021-03-10 00:00:00 | 11:56:00 | 00:00:33
2021-03-10 00:00:00 | 11:58:00 | 00:01:02
2021-03-10 00:00:00 | 12:27:00 | 00:11:47
2021-03-10 00:00:00 | 15:21:00 | 00:00:36
2021-03-10 00:00:00 | 15:23:00 | 00:00:36
2021-03-10 00:00:00 | 15:26:00 | 00:00:09
2021-03-11 00:00:00 | 11:49:00 | 00:01:04
2021-03-11 00:00:00 | 11:51:00 | 00:00:53
2021-03-11 00:00:00 | 11:53:00 | 00:00:36
2021-03-11 00:00:00 | 11:56:00 | 00:00:33
2021-03-11 00:00:00 | 11:58:00 | 00:01:05
2021-03-11 00:00:00 | 12:01:00 | 00:00:26
2021-03-11 00:00:00 | 12:03:00 | 00:00:55
2021-03-11 00:00:00 | 12:11:00 | 00:00:22
2021-03-11 00:00:00 | 12:13:00 | 00:02:55
2021-03-11 00:00:00 | 12:19:00 | 00:00:12
2021-03-11 00:00:00 | 12:31:00 | 00:00:24
2021-03-11 00:00:00 | 12:32:00 | 00:01:34
2021-03-11 00:00:00 | 12:37:00 | 00:01:04
2021-03-11 00:00:00 | 15:22:00 | 00:01:32
2021-03-11 00:00:00 | 15:24:00 | 00:00:12
2021-03-11 00:00:00 | 15:25:00 | 00:00:37
2021-03-11 00:00:00 | 15:27:00 | 00:00:46