Spreadsheet: 738890d1625318390-use-sumproduct-to-calculate-the-duration-for-a-particular-user-excel-help-file
Sheet: Sheet2

Call Date | Name | Direction | Duration | Duration_number |  | Trying to determine how much time [NAME] was on Inbound calls
2021-07-01 00:00:00 | [NAME] | Outbound | 00:05:04
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:28
2021-07-01 00:00:00 | [NAME] | Outbound | 00:13:32 |  |  | Sum of Duration_number | Column Labels
2021-07-01 00:00:00 | [NAME] | Inbound | 00:02:07 |  |  | Row Labels | Inbound | Outbound | Grand Total
2021-07-01 00:00:00 | [NAME] | Inbound | 00:01:56 |  |  | [NAME] | 1:39:53 | 0:29:33 | 2:09:26
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:49 |  |  | [NAME] | 2:02:00 | 0:15:17 | 2:17:17
2021-07-01 00:00:00 | [NAME] | Inbound | [NAME] |  |  | Grand Total | 3:41:53 | 0:44:50 | 4:26:43
2021-07-01 00:00:00 | [NAME] | Inbound | 00:07:06
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:57
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:58 |  |  | Sumproduct
2021-07-01 00:00:00 | [NAME] | Inbound | 00:01:02
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:55
2021-07-01 00:00:00 | [NAME] | Inbound | 00:03:01
2021-07-01 00:00:00 | [NAME] | Inbound | 00:02:21
2021-07-01 00:00:00 | [NAME] | Inbound | 00:06:05
2021-07-01 00:00:00 | [NAME] | Inbound | 00:02:31
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:25
2021-07-01 00:00:00 | [NAME] | Inbound | 00:06:35
2021-07-01 00:00:00 | [NAME] | Inbound | 00:01:27
2021-07-01 00:00:00 | [NAME] | Inbound | 00:03:54
2021-07-01 00:00:00 | [NAME] | Inbound | 00:02:02
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:11
2021-07-01 00:00:00 | [NAME] | Inbound | 00:22:23
2021-07-01 00:00:00 | [NAME] | Inbound | 00:01:12
2021-07-01 00:00:00 | [NAME] | Inbound | 00:01:01
2021-07-01 00:00:00 | [NAME] | Inbound | 00:13:30
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:43
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:12
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:50
2021-07-01 00:00:00 | [NAME] | Inbound | 00:02:48
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:19
2021-07-01 00:00:00 | [NAME] | Inbound | [NAME]
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:43
2021-07-01 00:00:00 | [NAME] | Inbound | 00:01:56
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:38
2021-07-01 00:00:00 | [NAME] | Inbound | 00:01:33
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:11
2021-07-01 00:00:00 | [NAME] | Outbound | 00:01:06
2021-07-01 00:00:00 | [NAME] | Outbound | 00:01:08
2021-07-01 00:00:00 | [NAME] | Outbound | [NAME]
2021-07-01 00:00:00 | [NAME] | Outbound | 00:00:56
2021-07-01 00:00:00 | [NAME] | Outbound | 00:01:22
2021-07-01 00:00:00 | [NAME] | Outbound | 00:01:07
2021-07-01 00:00:00 | [NAME] | Outbound | 00:02:40
2021-07-01 00:00:00 | [NAME] | Outbound | 00:00:50
2021-07-01 00:00:00 | [NAME] | Outbound | 00:01:11
2021-07-01 00:00:00 | [NAME] | Inbound | 00:05:32
2021-07-01 00:00:00 | [NAME] | Inbound | 00:03:06
2021-07-01 00:00:00 | [NAME] | Inbound | 00:04:14
2021-07-01 00:00:00 | [NAME] | Inbound | [NAME]
2021-07-01 00:00:00 | [NAME] | Inbound | 00:03:54
2021-07-01 00:00:00 | [NAME] | Inbound | 00:05:38
2021-07-01 00:00:00 | [NAME] | Inbound | 00:08:40
2021-07-01 00:00:00 | [NAME] | Inbound | 00:05:53
2021-07-01 00:00:00 | [NAME] | Inbound | 00:07:01
2021-07-01 00:00:00 | [NAME] | Inbound | 00:01:14
2021-07-01 00:00:00 | [NAME] | Inbound | 00:09:49
2021-07-01 00:00:00 | [NAME] | Inbound | 00:02:12
2021-07-01 00:00:00 | [NAME] | Inbound | 00:02:36
2021-07-01 00:00:00 | [NAME] | Inbound | 00:04:36
2021-07-01 00:00:00 | [NAME] | Inbound | 00:08:04
2021-07-01 00:00:00 | [NAME] | Inbound | 00:01:51
2021-07-01 00:00:00 | [NAME] | Inbound | 00:01:43
2021-07-01 00:00:00 | [NAME] | Inbound | 00:03:21
2021-07-01 00:00:00 | [NAME] | Inbound | 00:02:05
2021-07-01 00:00:00 | [NAME] | Inbound | 00:01:24
2021-07-01 00:00:00 | [NAME] | Inbound | 00:02:48
2021-07-01 00:00:00 | [NAME] | Inbound | 00:03:22
2021-07-01 00:00:00 | [NAME] | Inbound | 00:01:08
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:08
2021-07-01 00:00:00 | [NAME] | Inbound | [NAME]
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:05
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:17
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:06
2021-07-01 00:00:00 | [NAME] | Inbound | [NAME]
2021-07-01 00:00:00 | [NAME] | Inbound | 00:01:08
2021-07-01 00:00:00 | [NAME] | Inbound | 00:02:42
2021-07-01 00:00:00 | [NAME] | Inbound | 00:01:31
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:41
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:19
2021-07-01 00:00:00 | [NAME] | Inbound | 00:02:45
2021-07-01 00:00:00 | [NAME] | Inbound | 00:01:29
2021-07-01 00:00:00 | [NAME] | Inbound | [NAME]
2021-07-01 00:00:00 | [NAME] | Inbound | 00:01:27
2021-07-01 00:00:00 | [NAME] | Inbound | [NAME]
2021-07-01 00:00:00 | [NAME] | Inbound | [NAME]
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:46
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:13
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:25
2021-07-01 00:00:00 | [NAME] | Inbound | [NAME]
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:35
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:09
2021-07-01 00:00:00 | [NAME] | Inbound | 00:01:27
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:10
2021-07-01 00:00:00 | [NAME] | Inbound | 00:00:15
2021-07-01 00:00:00 | [NAME] | Inbound | 00:05:34
2021-07-01 00:00:00 | [NAME] | Outbound | 00:08:04
2021-07-01 00:00:00 | [NAME] | Outbound | 00:00:54
2021-07-01 00:00:00 | [NAME] | Outbound | 00:01:08
2021-07-01 00:00:00 | [NAME] | Outbound | 00:01:21
2021-07-01 00:00:00 | [NAME] | Outbound | 00:00:11
2021-07-01 00:00:00 | [NAME] | Outbound | 00:00:20
2021-07-01 00:00:00 | [NAME] | Outbound | 00:00:58
2021-07-01 00:00:00 | [NAME] | Outbound | 00:01:10
2021-07-01 00:00:00 | [NAME] | Outbound | 00:01:11