Spreadsheet: 854444d1704313307-if-and-to-get-a-name-from-a-list-based-on-date-and-time-plus-extract-tl-name-daily-tl-report
Sheet: Answered Contacts

Date | Starting time | TL | ID | Start Time | End Time
 |  | Need the name of the TL in shift based on the [NAME] time (D2) | 3b79acb5-f549-4a9e-a1e1-b4d332c77c12 | 2024-01-01 00:01:16 | 2024-01-01 00:02:49
 |  |  | 8a569c6d-cb7d-4775-8264-713deaf7a5ac | 2024-01-01 00:04:30 | 2024-01-01 00:05:58
 |  |  | 8fc6fdb8-bb18-4925-aab3-e7f95cef9b26 | 2024-01-01 00:17:29 | 2024-01-01 00:28:08
 |  |  | 8db13253-6ff0-4e60-86ba-0488809ba6e0 | 2024-01-01 00:50:57 | 2024-01-01 00:51:59
 |  |  | 47f92cf6-0991-47fc-87cd-90838ee4b53c | 2024-01-01 00:51:10 | 2024-01-01 01:01:38
 |  |  | 0e1182a2-b257-4a17-9bef-5294ffdd601c | 2024-01-01 00:52:00 | 2024-01-01 01:09:03
 |  |  | d4ca6e1a-278a-4cfa-b902-2d92b0e92542 | 2024-01-01 00:53:41 | 2024-01-01 01:05:13
 |  |  | 355abe69-0cd3-4c45-bc3e-f97e3a85f639 | 2024-01-01 00:54:52 | 2024-01-01 01:06:10
 |  |  | d2a9659c-2fc1-41e8-a11e-fd6f58377775 | 2024-01-01 01:00:16 | 2024-01-01 01:06:56
 |  |  | a0077a7f-70e5-49b2-94b3-a7e6b9658390 | 2024-01-01 01:03:55 | 2024-01-01 01:16:32
 |  |  | 4b3a7050-7aec-49e0-91e7-71e4b43d816b | 2024-01-01 02:25:39 | 2024-01-01 02:41:35
 |  |  | f5ef602f-ccec-4556-a46e-77b026da29d6 | 2024-01-01 02:26:19 | 2024-01-01 02:33:34
 |  |  | 5a6625c9-5b06-40ed-a0bb-f3576c19f171 | 2024-01-01 02:27:05 | 2024-01-01 02:33:07
 |  |  | 99ed8186-a25d-4a02-958a-a7ad213f544f | 2024-01-01 02:29:57 | 2024-01-01 02:32:47
 |  |  | f28e560d-c0ca-4ef6-aee0-920ea85645fe | 2024-01-01 02:53:50 | 2024-01-01 03:00:02
 |  |  | 9fa74b36-1d87-486a-9eec-79acee40b7e0 | 2024-01-01 02:54:39 | 2024-01-01 03:16:39
 |  |  | fbfa03db-b072-4873-b65a-53e64e127feb | 2024-01-01 02:55:03 | 2024-01-01 03:04:10
 |  |  | 080437aa-d93a-4316-8987-c8bb16a71951 | 2024-01-01 03:01:46 | 2024-01-01 03:57:22
 |  |  | 751cefd7-5b60-4740-ba33-e0b507ffae83 | 2024-01-01 03:02:42 | 2024-01-01 03:16:50
 |  |  | 6872e40f-d8ae-4d51-923e-01c197f33a6d | 2024-01-01 03:02:52 | 2024-01-01 03:13:39
 |  |  | 69617940-b994-4dc0-85d9-dea78dc2e054 | 2024-01-01 03:04:38 | 2024-01-01 03:14:11
 |  |  | 5dedc37e-9a4b-4a70-84bf-d4186f798825 | 2024-01-01 03:08:27 | 2024-01-01 03:21:12
 |  |  | 4ceb4c10-4cb1-482c-afef-d5a83cec3b71 | 2024-01-01 03:08:38 | 2024-01-01 03:19:43
 |  |  | d684ff4e-bd44-440c-b08a-8da7f92f89fc | 2024-01-01 03:13:50 | 2024-01-01 03:47:36
 |  |  | 840d8bc3-1441-4d09-b218-ef2a98a58ac6 | 2024-01-01 03:14:11 | 2024-01-01 03:22:27
 |  |  | 8ba5458f-775c-4ba3-b1a7-34cf39a9054e | 2024-01-01 03:54:24 | 2024-01-01 03:59:03
 |  |  | 549ead77-7189-46f2-bd26-86cdfdb6a042 | 2024-01-01 03:54:31 | 2024-01-01 04:00:20
 |  |  | 2f245b69-7f60-4285-9bcf-39001265e541 | 2024-01-01 03:56:28 | 2024-01-01 04:02:10
 |  |  | b3a9954c-a11e-464f-aacc-7655d1d8bf09 | 2024-01-01 04:02:57 | 2024-01-01 04:11:24
 |  |  | 96ae3ccf-0fa6-431e-a38b-90959ee8c98b | 2024-01-01 04:04:20 | 2024-01-01 04:18:43
 |  |  | cf740880-b420-4c7f-8317-90475974a037 | 2024-01-01 04:04:57 | 2024-01-01 04:21:03
 |  |  | [NAME]-77b389d55ef9 | 2024-01-01 04:55:25 | 2024-01-01 04:56:54
 |  |  | 2313536c-35ac-483e-bc4f-383e8c7baf41 | 2024-01-01 04:56:54 | 2024-01-01 05:02:07
 |  |  | f305670b-9e11-4ec0-b09b-697462e6cc89 | 2024-01-01 04:57:46 | 2024-01-01 05:15:26
 |  |  | b75c33bc-2d6a-4f73-81e1-96f3ecf29947 | 2024-01-01 05:00:30 | 2024-01-01 05:11:22
 |  |  | 4de7a9de-ece1-4081-8893-cd8ba94d4de8 | 2024-01-01 05:01:35 | 2024-01-01 05:14:07
 |  |  | 57365621-bef5-48d5-84e7-efb41bcfe3f6 | 2024-01-01 05:01:39 | 2024-01-01 05:20:25
 |  |  | 0e003794-3f04-4d16-a5c3-bc2008618dfa | 2024-01-01 05:02:58 | 2024-01-01 05:32:04
 |  |  | a5dfca5e-23b4-4886-bb05-c91d38ca286c | 2024-01-01 22:57:21 | 2024-01-01 23:06:37
 |  |  | 2187cf58-1690-4e5e-bf09-35cad14056c1 | 2024-01-01 22:58:14 | 2024-01-01 23:03:28
 |  |  | 41e62ad0-b4ca-4e65-ac6c-de726bb5ba3c | 2024-01-01 22:58:33 | 2024-01-01 23:01:30
 |  |  | d9990610-18c8-43b9-afd3-22749a1c4d4b | 2024-01-01 22:59:20 | 2024-01-01 23:07:16
 |  |  | ebb3784e-325d-462c-8d96-ebba1209258d | 2024-01-01 22:59:37 | 2024-01-01 23:04:21
 |  |  | 42e73b1d-6443-4352-982d-f8b04793fbae | 2024-01-01 23:00:16 | 2024-01-01 23:06:22
 |  |  | b38e6d38-78bb-4908-8574-340a649f6d3d | 2024-01-01 23:02:15 | 2024-01-01 23:04:24
 |  |  | adca1ee6-faad-4a0b-b8bc-035aa5e6c1f5 | 2024-01-01 23:02:50 | 2024-01-01 23:09:28
 |  |  | 24ca0290-e06f-43a8-8bbc-11759fb25d4e | 2024-01-01 23:04:35 | 2024-01-01 23:13:03
 |  |  | 1a12228d-9b55-440f-8cc8-cd0d075df149 | 2024-01-01 23:06:27 | 2024-01-01 23:16:26
 |  |  | f1537ef5-8f29-4967-ad04-96f8e60ed799 | 2024-01-01 23:06:44 | 2024-01-01 23:11:09
 |  |  | e4654bfd-f778-416c-8935-2c357ac20c3f | 2024-01-01 23:07:47 | 2024-01-01 23:19:28
 |  |  | 0ce449b3-1b08-4491-9938-0fbb47dcf863 | 2024-01-01 23:12:14 | 2024-01-01 23:20:00
 |  |  | c7e272ef-a575-4bf3-bd66-f6ace82cd60b | 2024-01-01 23:14:21 | 2024-01-01 23:33:10
 |  |  | 6756625c-7d4b-4235-9009-6118ed3e8c8f | 2024-01-01 23:17:29 | 2024-01-01 23:26:46
 |  |  | c93fba74-2894-46c9-a23a-96eda683b52e | 2024-01-01 23:17:33 | 2024-01-01 23:39:52
 |  |  | 070e1ecf-ab87-49de-9606-f0c81d63aaae | 2024-01-01 23:19:21 | 2024-01-01 23:30:11
 |  |  | 9bd37101-a8cf-4ee9-910d-c701ad14b702 | 2024-01-01 23:19:37 | 2024-01-01 23:25:17
 |  |  | 27e2c825-9c0d-46a0-a5e4-ef52617d37d7 | 2024-01-01 23:57:25 | 2024-01-02 00:17:24
 |  |  | 90a431b9-2db0-4392-88ab-40478bc0cef6 | 2024-01-01 23:57:33 | 2024-01-02 00:11:55
 |  |  | c848cb36-3003-4092-83da-3fd750951e78 | 2024-01-01 23:58:17 | 2024-01-02 00:01:51
 |  |  | 2e41b165-6cea-467f-9900-a5a834a9ebc1 | 2024-01-01 23:58:27 | 2024-01-02 00:21:30