Spreadsheet: 784356d1655673296-amend-formula-to-take-other-conditions-into-account-test1
Sheet: 12345

URN | Date | Time | Mapped |  |  |  |  |  | Call Type | Duration | End Time | First Cell |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B&b | Morning/Night | First/Last | Dormant Periods |  | Rest | Data Check | Data Check |  | HH | MM | SS
1 | 2020-03-25 00:00:00 | 23:00:00 |  |  |  |  |  |  | Data | 00:00:00 | 23:00:00 | 9758089
2 | 2020-03-26 00:00:00 | 00:55:44 |  |  |  |  |  |  | Data | 00:00:00 | 00:55:44 | 9086666
3 | 2020-03-26 00:00:00 | 01:55:44 |  |  |  |  |  |  | Data | 00:00:00 | 01:55:44 | 9086666
4 | 2020-03-26 00:00:00 | 02:55:44 |  |  |  |  |  |  | Data | 00:00:00 | 02:55:44 | 9086666
5 | 2020-03-26 00:00:00 | 03:55:44 |  |  |  |  |  |  | Data | 00:00:00 | 03:55:44 | 9086666
6 | 2020-03-26 00:00:00 | 04:55:44 |  |  |  |  |  |  | Data | 00:00:00 | 04:55:44 | 9086666
7 | 2020-03-26 00:00:00 | 05:55:44 |  |  |  |  |  |  | Data | 00:00:00 | 05:55:44 | 9086666
8 | 2020-03-26 00:00:00 | 06:55:44 |  |  |  |  |  |  | Data | 00:00:00 | 06:55:44 | 9086666
9 | 2020-03-26 00:00:00 | 07:55:44 |  |  |  |  |  |  | Data | 00:00:00 | 07:55:44 | 9086666
10 | 2020-03-26 00:00:00 | 08:45:00 |  |  |  |  |  |  | Data | 00:00:00 | 08:45:00 | 9086679
11 | 2020-03-26 00:00:00 | 08:49:07 |  |  |  |  |  |  | Data | 00:00:00 | 08:49:07 | 9086666
12 | 2020-03-26 00:00:00 | 09:30:29 |  |  |  |  |  |  | Data | 00:00:00 | 09:30:29 | 9086666
13 | 2020-03-26 00:00:00 | 09:48:12 |  |  |  |  |  |  | Data | 00:00:00 | 09:48:12 | 9086666
14 | 2020-03-26 00:00:00 | 10:28:48 |  |  |  |  |  |  | Data | 00:00:00 | 10:28:48 | 507068
15 | 2020-03-26 00:00:00 | 10:40:37 |  |  |  |  |  |  | Data | 00:00:00 | 10:40:37 | 8807998
16 | 2020-03-26 00:00:00 | 11:01:31 |  |  |  |  |  |  | Data | 00:00:00 | 11:01:31 | 8967078
17 | 2020-03-26 00:00:00 | 11:04:02 |  |  |  |  |  |  | Data | 00:00:00 | 11:04:02 | 8788586
18 | 2020-03-26 00:00:00 | 11:07:42 |  |  |  |  |  |  | Data | 00:00:00 | 11:07:42 | 8966866
19 | 2020-03-26 00:00:00 | 11:28:48 |  |  |  |  |  |  | Data | 00:00:00 | 11:28:48 | 8966866
20 | 2020-03-26 00:00:00 | 11:36:37 |  |  |  |  |  |  | Data | 00:00:00 | 11:36:37 | 8877599
21 | 2020-03-26 00:00:00 | 12:18:54 |  |  |  |  |  |  | Data | 00:00:00 | 12:18:54 | 8779009
22 | 2020-03-26 00:00:00 | 12:24:16 |  |  |  |  |  |  | Data | 00:00:00 | 12:24:16 | 8857956
23 | 2020-03-26 00:00:00 | 12:26:37 |  |  |  |  |  |  | Data | 00:00:00 | 12:26:37 | 8857960
24 | 2020-03-26 00:00:00 | 12:29:57 |  |  |  |  |  |  | Data | 00:00:00 | 12:29:57 | 8857956
25 | 2020-03-26 00:00:00 | 12:31:19 |  |  |  |  |  |  | Data | 00:00:00 | 12:31:19 | 8857960
26 | 2020-03-26 00:00:00 | 12:35:49 |  |  |  |  |  |  | Data | 00:00:00 | 12:35:49 | 8708666
27 | 2020-03-26 00:00:00 | 23:00:00 |  |  |  |  |  |  | Data | 00:00:00 | 12:36:40 | 8708666
28 | 2020-03-26 00:00:00 | 00:55:44 |  |  |  |  |  |  | Data | 06:00:00 | 12:42:40 | 8675078
29 | 2020-03-26 00:00:00 | 01:55:44 |  |  |  |  |  |  | Data | 06:00:00 | 12:46:17 | 7960878
30 | 2020-03-26 00:00:00 | 02:55:44 |  |  |  |  |  |  | Data | 06:00:00 | 12:51:01 | 7960878
31 | 2020-03-26 00:00:00 | 03:55:44 |  |  |  |  |  |  | Data | 00:00:00 | 12:52:25 | 8568888
32 | 2020-03-26 00:00:00 | 04:55:44 |  |  |  |  |  |  | Data | 00:00:00 | 12:53:57 | 8568888
33 | 2020-03-26 00:00:00 | 05:55:44 |  |  |  |  |  |  | Data | 00:00:00 | 12:54:48 | 8568896
34 | 2020-03-26 00:00:00 | 06:55:44 |  |  |  |  |  |  | Data | 00:00:00 | 12:58:39 | 8560078
35 | 2020-03-26 00:00:00 | 07:55:44 |  |  |  |  |  |  | Data | 00:00:00 | 13:02:58 | 9767806
36 | 2020-03-26 00:00:00 | 08:45:00 |  |  |  |  |  |  | Data | 00:00:00 | 13:03:22 | 8560076
37 | 2020-03-26 00:00:00 | 08:49:07 |  |  |  |  |  |  | Data | 00:00:00 | 13:10:01 | 8566958
38 | 2020-03-26 00:00:00 | 13:19:12 |  |  |  |  |  |  | Data | 00:00:00 | 13:19:12 | 7085958
39 | 2020-03-26 00:00:00 | 13:24:47 |  |  |  |  |  |  | Data | 00:00:00 | 13:24:47 | 8679999
40 | 2020-03-26 00:00:00 | 13:25:43 |  |  |  |  |  |  | Data | 00:00:00 | 13:25:43 | 8679906