Spreadsheet: 137869d1327416454-i-am-trying-to-write-an-array-with-multiple-if-conditions-raw_data
Sheet: calls data

Date | Agent Name | Total ACD Calls | Total ACD Time | Total ACW Time | Total Hold Time | Used formula to calculate all the data at a time
2012-01-01 00:00:00 | Ab | 7 | 03:44:06 | 00:05:28 | 00:00:00
2012-01-01 00:00:00 | C | 8 | 05:17:50 | 00:00:49 | 00:09:36
2012-01-01 00:00:00 | D | 6 | 05:05:22 | 00:01:49 | 00:22:18
2012-01-01 00:00:00 | E | 6 | 05:24:23 | 00:02:13 | 00:09:06
2012-01-01 00:00:00 | f | 6 | 06:45:47 | 00:00:00 | 00:23:00
2012-01-02 00:00:00 | g | 18 | 06:35:03 | 00:11:27 | 00:07:38
2012-01-02 00:00:00 | Ab | 15 | 06:13:09 | 00:12:14 | 00:32:54 | Need like between the dates
2012-01-02 00:00:00 | C | 15 | 06:18:52 | 00:00:00 | 00:56:28.500000
2012-01-02 00:00:00 | D | 10 | 06:12:56 | 00:06:08 | 00:31:54
2012-01-02 00:00:00 | E | 11 | 07:32:43 | 00:05:27 | 00:24:52 |  | Start Date: | 2012-01-15 00:00:00
2012-01-02 00:00:00 | f | 5 | 03:07:28 | 00:01:18 | 00:40:10 |  | End Date: | 2012-01-21 00:00:00
2012-01-02 00:00:00 | g | 10 | 07:39:03 | 00:03:57 | 00:16:28.500000
2012-01-02 00:00:00 | Ab | 11 | 08:28:46 | 00:00:00 | 00:30:13.333000
2012-01-02 00:00:00 | C | 8 | 06:56:46 | 00:00:00 | 00:36:38
2012-01-03 00:00:00 | D | 19 | 06:51:52 | 00:13:18 | 01:07:10 |  | Result : | ????????
2012-01-03 00:00:00 | E | 14 | 06:39:06 | 00:04:20 | 00:04:40
2012-01-03 00:00:00 | f | 14 | 05:30:38 | 00:00:00 | 01:35:41.714000
2012-01-03 00:00:00 | g | 13 | 06:09:51 | 00:00:00 | 01:06:07
2012-01-03 00:00:00 | Ab | 13 | 06:59:09 | 00:16:38 | 00:11:05.500000
2012-01-03 00:00:00 | C | 12 | 08:01:14 | 00:00:33 | 00:03:24
2012-01-03 00:00:00 | D | 10 | 06:20:53 | 00:05:28 | 00:38:15
2012-01-03 00:00:00 | E | 13 | 09:28:12 | 00:00:00 | 00:03:04
2012-01-03 00:00:00 | f | 10 | 08:23:09 | 00:03:47 | 00:16:10
2012-01-04 00:00:00 | g | 22 | 06:12:17 | 00:30:29 | 00:35:16.500000
2012-01-04 00:00:00 | Ab | 8 | 03:18:49 | 00:02:55 | 00:37:36.889000
2012-01-04 00:00:00 | C | 13 | 06:47:42 | 00:00:00 | 00:40:18
2012-01-04 00:00:00 | D | 1 | 00:51:59 | 00:00:00 | 00:00:00
2012-01-04 00:00:00 | E | 8 | 06:50:52 | 00:06:11 | 00:27:15
2012-01-05 00:00:00 | f | 37 | 05:14:36 | 00:03:47 | 00:02:12
2012-01-05 00:00:00 | g | 1 | 00:24:12 | 00:00:02 | 00:00:00
2012-01-05 00:00:00 | Ab | 15 | 07:48:29 | 00:00:46 | 00:33:59.333000
2012-01-05 00:00:00 | C | 21 | 08:13:46 | 00:00:00 | 04:02:34.800000
2012-01-05 00:00:00 | D | 10 | 06:08:33 | 00:03:18 | 00:04:23
2012-01-05 00:00:00 | E | 9 | 07:35:22 | 00:00:00 | 00:25:22.800000
2012-01-05 00:00:00 | f | 7 | 06:30:56 | 00:03:42 | 00:11:22
2012-01-06 00:00:00 | g | 34 | 07:56:21 | 00:25:39 | 00:26:14
2012-01-06 00:00:00 | Ab | 16 | 05:55:07 | 00:01:55 | 00:43:01.333000
2012-01-06 00:00:00 | C | 12 | 05:16:48 | 00:07:30 | 00:03:44
2012-01-06 00:00:00 | D | 9 | 04:03:40 | 00:05:18 | 00:15:30
2012-01-06 00:00:00 | E | 12 | 05:38:06 | 00:00:00 | 00:59:06.500000
2012-01-06 00:00:00 | f | 11 | 05:59:41 | 00:04:51 | 00:13:12
2012-01-06 00:00:00 | g | 8 | 08:27:22 | 00:18:09 | 00:03:48
2012-01-06 00:00:00 | Ab | 5 | 10:32:20 | 00:00:00 | 00:10:16
2012-01-07 00:00:00 | C | 1 | 00:00:00 | 00:01:31 | 00:00:00
2012-01-07 00:00:00 | D | 23 | 06:57:48 | 00:41:16 | 00:47:04.167000
2012-01-07 00:00:00 | E | 14 | 05:32:57 | 00:10:23 | 00:18:27
2012-01-07 00:00:00 | f | 12 | 06:45:46 | 00:12:48 | 00:00:00
2012-01-07 00:00:00 | g | 14 | 07:36:32 | 00:16:12 | 00:21:50
2012-01-07 00:00:00 | Ab | 13 | 07:17:24 | 00:00:00 | 00:53:41.667000
2012-01-08 00:00:00 | C | 2 | 00:46:30 | 00:00:17 | 00:02:44
2012-01-08 00:00:00 | D | 21 | 08:22:10 | 00:23:09 | 01:30:54
2012-01-08 00:00:00 | E | 17 | 08:22:48 | 00:21:35 | 00:24:48
2012-01-08 00:00:00 | f | 14 | 07:54:43 | 00:13:09 | 00:45:13
2012-01-08 00:00:00 | g | 13 | 07:33:16 | 00:00:00 | 01:09:11.500000
2012-01-08 00:00:00 | Ab | 8 | 06:32:55 | 00:04:53 | 00:17:58
2012-01-08 00:00:00 | C | 4 | 07:46:33 | 00:00:25 | 00:00:00
2012-01-09 00:00:00 | D | 34 | 07:26:26 | 00:21:27 | 00:21:54.500000
2012-01-09 00:00:00 | E | 7 | 03:13:12 | 00:02:12 | 00:01:16
2012-01-09 00:00:00 | f | 23 | 10:25:03 | 00:00:00 | 00:22:30
2012-01-09 00:00:00 | g | 16 | 10:03:58 | 00:08:03 | 00:00:00
2012-01-09 00:00:00 | Ab | 1 | 00:35:39 | 00:00:16 | 00:05:43
2012-01-09 00:00:00 | C | 12 | 07:39:04 | 00:00:00 | 00:51:01.500000
2012-01-09 00:00:00 | D | 8 | 06:37:14 | 00:05:20 | 00:00:00
2012-01-09 00:00:00 | E | 7 | 05:39:17 | 00:05:04 | 00:20:02
2012-01-09 00:00:00 | f | 10 | 08:23:42 | 00:08:26 | 00:13:04
2012-01-10 00:00:00 | g | 18 | 06:28:10 | 00:16:21 | 00:43:15
2012-01-10 00:00:00 | Ab | 20 | 07:15:37 | 00:00:00 | 01:18:34.111000
2012-01-10 00:00:00 | C | 9 | 04:20:22 | 00:03:41 | 00:18:31.600000
2012-01-10 00:00:00 | D | 11 | 07:44:37 | 00:04:42 | 00:00:00
2012-01-10 00:00:00 | E | 8 | 09:06:54 | 00:00:00 | 00:14:29
2012-01-11 00:00:00 | f | 12 | 05:37:40 | 00:00:00 | 00:08:36
2012-01-11 00:00:00 | g | 12 | 06:06:57 | 00:04:45 | 00:00:00
2012-01-11 00:00:00 | Ab | 7 | 04:15:24 | 00:00:31 | 00:15:21.750000
2012-01-11 00:00:00 | C | 9 | 05:33:14 | 00:11:20 | 00:56:52.500000
2012-01-12 00:00:00 | D | 1 | 00:03:21 | 00:00:01 | 00:02:25
2012-01-12 00:00:00 | E | 19 | 06:12:02 | 00:29:20 | 00:03:48
2012-01-12 00:00:00 | f | 16 | 05:59:52 | 00:00:00 | 00:02:53.500000
2012-01-12 00:00:00 | g | 10 | 06:34:26 | 00:06:49 | 00:17:04
2012-01-13 00:00:00 | Ab | 1 | 00:00:00 | 00:01:03 | 00:00:00
2012-01-13 00:00:00 | C | 17 | 05:26:34 | 00:00:00 | 01:02:04.667000
2012-01-13 00:00:00 | D | 9 | 03:27:00 | 00:06:47 | 00:20:42
2012-01-13 00:00:00 | E | 11 | 05:01:21 | 00:00:07 | 00:35:13
2012-01-13 00:00:00 | f | 8 | 06:33:46 | 00:02:44 | 00:24:33.500000
2012-01-13 00:00:00 | g | 7 | 07:44:54 | 00:00:00 | 00:05:27.500000
2012-01-14 00:00:00 | Ab | 13 | 06:12:41 | 00:00:00 | 00:19:31
2012-01-14 00:00:00 | C | 15 | 06:18:17 | 00:00:00 | 01:25:55.417000
2012-01-14 00:00:00 | D | 15 | 07:06:38 | 00:14:03 | 00:52:09
2012-01-14 00:00:00 | E | 4 | 02:36:15 | 00:04:11 | 00:14:18
2012-01-14 00:00:00 | f | 7 | 05:22:35 | 00:02:12 | 00:04:54
2012-01-14 00:00:00 | g | 7 | 06:40:31 | 00:05:04 | 00:11:30
2012-01-14 00:00:00 | Ab | 7 | 07:44:49 | 00:00:00 | 00:10:09
2012-01-15 00:00:00 | C | 11 | 05:53:35 | 00:00:00 | 00:00:00
2012-01-15 00:00:00 | D | 15 | 06:59:14 | 00:00:00 | 01:30:06.273000
2012-01-15 00:00:00 | E | 12 | 06:00:50 | 00:12:11 | 00:47:30
2012-01-15 00:00:00 | f | 13 | 07:47:47 | 00:16:24 | 00:00:00
2012-01-15 00:00:00 | g | 12 | 08:28:33 | 00:00:00 | 00:00:00
2012-01-16 00:00:00 | Ab | 5 | 00:02:00 | 00:00:16 | 00:00:00
2012-01-16 00:00:00 | C | 1 | 00:04:14 | 00:00:41 | 00:03:16
2012-01-16 00:00:00 | D | 8 | 02:28:18 | 00:01:05 | 00:32:16.500000
2012-01-16 00:00:00 | E | 19 | 06:53:38 | 00:02:52 | 01:22:23.714000
2012-01-16 00:00:00 | f | 16 | 07:09:30 | 00:15:27 | 01:01:00
2012-01-16 00:00:00 | g | 14 | 07:19:53 | 00:00:00 | 00:09:12
2012-01-16 00:00:00 | Ab | 14 | 08:22:40 | 00:00:00 | 00:21:07
2012-01-16 00:00:00 | C | 12 | 07:34:07 | 00:02:39 | 00:00:00
2012-01-17 00:00:00 | D | 13 | 04:54:02 | 00:09:35 | 00:45:22
2012-01-17 00:00:00 | E | 15 | 06:01:35 | 00:10:31 | 00:55:30
2012-01-17 00:00:00 | f | 14 | 06:49:49 | 00:12:18 | 00:59:15.857000
2012-01-17 00:00:00 | g | 11 | 06:47:26 | 00:14:05 | 00:02:53
2012-01-17 00:00:00 | Ab | 11 | 07:14:48 | 00:24:05 | 00:15:54
2012-01-17 00:00:00 | C | 11 | 08:26:43 | 00:00:00 | 00:00:00
2012-01-18 00:00:00 | D | 1 | 00:00:45 | 00:00:25 | 00:00:00
2012-01-18 00:00:00 | E | 1 | 00:12:52 | 00:00:04 | 00:00:00
2012-01-18 00:00:00 | f | 10 | 06:12:23 | 00:00:00 | 00:06:47
2012-01-18 00:00:00 | g | 13 | 07:23:23 | 00:12:26 | 00:42:34.667000
2012-01-18 00:00:00 | Ab | 9 | 04:51:21 | 00:09:53 | 00:53:56.133000
2012-01-18 00:00:00 | C | 9 | 05:32:36 | 00:00:00 | 00:24:32
2012-01-18 00:00:00 | D | 10 | 06:57:23 | 00:02:29 | 00:00:00
2012-01-19 00:00:00 | E | 22 | 05:50:33 | 00:14:08 | 00:49:24.500000
2012-01-19 00:00:00 | f | 19 | 07:01:46 | 00:11:24 | 00:59:58
2012-01-19 00:00:00 | g | 12 | 05:59:59 | 00:00:00 | 00:03:36
2012-01-19 00:00:00 | Ab | 10 | 06:13:37 | 00:00:00 | 01:05:57.572000
2012-01-19 00:00:00 | C | 8 | 06:40:15 | 00:00:00 | 00:36:08.500000
2012-01-19 00:00:00 | D | 6 | 06:27:26 | 00:02:27 | 00:00:00
2012-01-20 00:00:00 | E | 15 | 05:45:25 | 00:05:19 | 00:00:00
2012-01-20 00:00:00 | f | 13 | 05:15:06 | 00:00:00 | 00:57:55.500000
2012-01-20 00:00:00 | g | 15 | 06:10:41 | 00:05:37 | 01:40:30
2012-01-20 00:00:00 | Ab | 10 | 05:38:09 | 00:25:15 | 00:03:30
2012-01-20 00:00:00 | C | 11 | 05:30:08 | 00:00:00 | 01:23:12
2012-01-20 00:00:00 | D | 9 | 05:31:38 | 00:00:00 | 00:17:39
2012-01-20 00:00:00 | E | 11 | 07:55:54 | 00:04:31 | 00:00:00
2012-01-20 00:00:00 | f | 3 | 02:17:55 | 00:00:00 | 00:07:39
2012-01-21 00:00:00 | g | 14 | 06:16:48 | 00:16:22 | 00:40:38.400000
2012-01-21 00:00:00 | Ab | 12 | 06:48:27 | 00:00:00 | 00:03:36
2012-01-21 00:00:00 | C | 10 | 05:35:56 | 00:26:31 | 00:13:42
2012-01-21 00:00:00 | D | 6 | 04:57:11 | 00:00:47 | 00:00:00
2012-01-21 00:00:00 | E | 5 | 05:48:47 | 00:00:00 | 00:21:08
2012-01-21 00:00:00 | f | 2 | 02:28:07 | 00:00:19 | 00:10:36
2012-01-22 00:00:00 | g | 1 | 00:09:28 | 00:00:00 | 00:02:00
2012-01-22 00:00:00 | Ab | 11 | 04:09:29 | 00:03:34 | 00:17:47
2012-01-22 00:00:00 | C | 8 | 03:58:47 | 00:01:53 | 00:00:00
2012-01-22 00:00:00 | Ab | 9 | 04:29:12 | 00:10:20 | 00:00:22
2012-01-22 00:00:00 | C | 9 | 04:31:14 | 00:00:00 | 00:35:34.333000
2012-01-22 00:00:00 | D | 10 | 05:21:02 | 00:03:07 | 00:17:33
2012-01-22 00:00:00 | E | 14 | 06:42:20 | 00:21:58 | 01:07:48
2012-01-22 00:00:00 | f | 10 | 06:05:16 | 00:00:00 | 00:32:33
2012-01-22 00:00:00 | g | 6 | 04:56:21 | 00:00:00 | 00:01:38