Spreadsheet: 727241d1617796476-need-to-extract-data-from-other-sheet-based-on-name-date-and-time-range-to-avoid-duplicates-varun_task-manager-copy_upload-1-
Sheet: Data'21

 |  |  |  |  |  | put away containers
 | Date | Workers Name | Activity | Start Time | End Time | Workorder | Quantity | Images | Containers | Expected Result | Files | Total Time | Time in Minutes | Images/Min | Quantity/Min | Containers/Min | Files/Min | Comments | Department | Location
 | 2021-02-22 00:00:00 | [NAME] | RETRIEVAL: OFFSITE | 2021-02-22 15:03:41 | 2021-02-22 17:38:48 |  |  |  |  |  | 18 |  |  |  |  |  |  | north side pm pick |  | ONSITE
 | 2021-02-22 00:00:00 | [NAME] | RETRIEVAL: OFFSITE | 2021-02-22 15:03:43 | 2021-02-22 17:38:50 |  |  |  |  |  | 18 |  |  |  |  |  |  | north side pm pick
 | 2021-02-22 00:00:00 | [NAME] | RETRIEVAL: OFFSITE | 2021-02-22 15:04:26 | 2021-02-22 17:06:36 |  |  | 1 |  |  | 10 |  |  |  |  |  |  | DH pm pick
 | 2021-02-22 00:00:00 | [NAME] | PRINT BOX BARCODES | 2021-02-22 15:16:05 | 2021-02-22 15:26:16
 | 2021-02-24 00:00:00 | [NAME] | RETRIEVAL: OFFSITE | 2021-02-24 13:55:42 | 2021-02-24 17:03:26 |  |  |  |  |  |  |  |  |  |  |  |  | Picking attachments & PM pick DH
 | 2021-02-24 00:00:00 | [NAME] | SORTING: INCOMING BOXES | 2021-02-24 14:22:38 | 2021-02-24 14:45:20
 | 2021-02-24 00:00:00 | [NAME] | SORTING: INCOMING BOXES | 2021-02-24 14:20:38 | 2021-02-24 14:45:20
 | 2021-02-24 00:00:00 | [NAME] | RETRIEVAL: OFFSITE | 2021-02-24 14:48:31 | 2021-02-24 17:59:41
 | 2021-02-24 00:00:00 | [NAME] | RETRIEVAL: OFFSITE | 2021-02-24 14:48:38 | 2021-02-24 17:59:44
 | 2021-02-24 00:00:00 | [NAME] | ONLINE TRAINING COURSE | 2021-02-24 17:04:22 | 2021-02-24 17:59:44
 | 2021-02-25 00:00:00 | [NAME] | PUT AWAY CONTAINERS: OFFSITE | 2021-02-25 07:01:53 | 2021-02-25 14:00:44
 | 2021-02-25 00:00:00 | [NAME] | PUT AWAY CONTAINERS: OFFSITE | 2021-02-25 07:01:53 | 2021-02-25 14:00:44
 | 2021-02-25 00:00:00 | [NAME] | ACTIVITIES: [NAME]-TRANSFERS | 2021-02-25 07:01:54 | 2021-02-25 09:33:24
 | 2021-02-25 00:00:00 | Masfiqur Rahman | SORTING: INCOMING BOXES | 2021-02-25 07:01:55 | 2021-02-25 07:53:24
 | 2021-02-25 00:00:00 | [NAME] | SORTING: INCOMING BOXES | 2021-02-25 07:01:55 | 2021-02-25 07:53:24
 | 2021-02-25 00:00:00 | Radmila Ristivojevic | SORTING: TUB ROOM | 2021-02-25 07:59:31 | 2021-02-25 15:58:43
 | 2021-02-25 00:00:00 | [NAME] | OTHER: ASSISTING DEPARTMENTS | 2021-02-25 07:59:29 | 2021-02-25 10:21:59
 | 2021-02-25 00:00:00 | Masfiqur Rahman | PUT AWAY CONTAINERS: ONSITE | 2021-02-25 07:54:28 | 2021-02-25 14:25:44
 | 2021-02-25 00:00:00 | [NAME] | PUT AWAY CONTAINERS: ONSITE | 2021-02-25 07:54:28 | 2021-02-25 10:44:40
 | 2021-02-25 00:00:00 | [NAME] | PERSONAL ADMINISTRATION | 2021-02-25 09:37:58 | 2021-02-25 10:00:39
 | 2021-02-25 00:00:00 | [NAME] | PUT AWAY RECORDS: ONSITE | 2021-02-25 10:00:42 | 2021-02-25 16:59:50
 | 2021-02-25 00:00:00 | [NAME] | PUT AWAY CONTAINERS: ONSITE | 2021-02-25 10:01:26 | 2021-02-25 17:57:39
 | 2021-02-25 00:00:00 | [NAME] | RETRIEVAL: OFFSITE | 2021-02-25 09:33:24 | 2021-02-25 11:30:36
 | 2021-02-25 00:00:00 | [NAME] | RETRIEVAL: OFFSITE | 2021-02-25 10:30:31 | 2021-02-25 12:17:36
 | 2021-02-25 00:00:00 | [NAME] | RETRIEVAL: SYSCON | 2021-02-25 10:30:28 | 2021-02-25 12:11:36
 | 2021-02-25 00:00:00 | [NAME] | GENERAL HOUSEKEEPING | 2021-02-25 10:30:32 | 2021-02-25 14:36:06
 | 2021-02-25 00:00:00 | [NAME] | RETRIEVAL: OFFSITE | 2021-02-25 10:30:33 | 2021-02-25 12:17:41
 | 2021-02-25 00:00:00 | [NAME] | PUT AWAY RECORDS: ONSITE | 2021-02-25 10:44:30 | 2021-02-25 15:30:19
 | 2021-02-25 00:00:00 | [NAME] | PREPARING PALLETS | 2021-02-25 10:44:57 | 2021-02-25 13:39:43
 | 2021-02-25 00:00:00 | [NAME] | ACTIVITIES: [NAME]-TRANSFERS | 2021-02-25 12:12:09 | 2021-02-25 14:00:44
 | 2021-02-25 00:00:00 | [NAME] | PRINT BOX BARCODES | 2021-02-25 12:17:44 | 2021-02-25 13:39:43 |  |  |  |  |  |  |  |  |  |  |  |  | 11,950 f barcodes
 | 2021-02-25 00:00:00 | [NAME] | PUT AWAY CONTAINERS: ONSITE | 2021-02-25 12:20:28 | 2021-02-25 13:39:43
 | 2021-02-25 00:00:00 | [NAME] | PUT AWAY CONTAINERS: ONSITE | 2021-02-25 12:12:09 | 2021-02-25 13:39:43 |  |  |  |  | 0
 | 2021-02-25 00:00:00 | [NAME] | RETRIEVAL: HEALTH SENTENCE | 2021-02-25 13:30:45 | 2021-02-25 13:39:43
 | 2021-02-25 00:00:00 | [NAME] | SORTING: INCOMING BOXES | 2021-02-25 13:39:45 | 2021-02-25 15:00:30
 | 2021-02-25 00:00:00 | [NAME] | SORTING: INCOMING BOXES | 2021-02-25 13:39:45 | 2021-02-25 14:36:25
 | 2021-02-25 00:00:00 | [NAME] | SORTING: INCOMING BOXES | 2021-02-25 13:39:45 | 2021-02-25 14:29:41
 | 2021-02-25 00:00:00 | [NAME] | SORTING: INCOMING BOXES | 2021-02-25 13:39:45 | 2021-02-25 15:00:35
 | 2021-02-25 00:00:00 | [NAME] | RETRIEVAL: OFFSITE | 2021-02-25 15:01:06 | 2021-02-25 17:57:36
 | 2021-02-25 00:00:00 | [NAME] | RETRIEVAL: OFFSITE | 2021-02-25 15:01:09 | 2021-02-25 17:57:39
 | 2021-02-25 00:00:00 | [NAME] | RETRIEVAL: OFFSITE | 2021-02-25 14:37:11 | 2021-02-25 17:04:20
 | 2021-02-25 00:00:00 | [NAME] | PUT AWAY CONTAINERS: ONSITE | 2021-02-25 14:37:19 | 2021-02-25 17:57:42 |  |  |  |  | 90
 | 2021-02-25 00:00:00 | [NAME] | PUT AWAY RECORDS: ONSITE | 2021-02-25 17:04:34 | 2021-02-25 17:57:44
 | 2021-02-26 00:00:00 | [NAME] | PUT AWAY RECORDS: ONSITE | 2021-02-26 07:04:52 | 2021-02-26 14:00:00
 | 2021-02-26 00:00:00 | [NAME] | SORTING: INCOMING BOXES | 2021-02-26 07:04:54 | 2021-02-26 07:34:46
 | 2021-02-26 00:00:00 | Masfiqur Rahman | PUT AWAY CONTAINERS: ONSITE | 2021-02-26 07:04:54 | 2021-02-26 14:00:00
 | 2021-02-26 00:00:00 | [NAME] | PUT AWAY CONTAINERS: OFFSITE | 2021-02-26 07:04:54 | 2021-02-26 14:00:00
 | 2021-02-26 00:00:00 | [NAME] | PUT AWAY CONTAINERS: OFFSITE | 2021-02-26 07:04:55 | 2021-02-26 14:00:00
 | 2021-02-26 00:00:00 | [NAME] | PREPARING PALLETS | 2021-02-26 07:34:51 | 2021-02-26 09:18:36
 | 2021-02-26 00:00:00 | [NAME] | ACTIVITIES: HEALTH SENTENCE | 2021-02-26 08:00:44 | 2021-02-26 09:18:36
 | 2021-02-26 00:00:00 | Radmila Ristivojevic | SORTING: TUB ROOM | 2021-02-26 08:00:44 | 2021-02-26 11:00:06
 | 2021-02-26 00:00:00 | [NAME] | RETRIEVAL: URGENT | 2021-02-26 09:35:32 | 2021-02-26 10:41:05 |  |  | 1 |  |  |  |  |  |  |  |  |  | URGENT IMAGE AR1
 | 2021-02-26 00:00:00 | [NAME] | GENERAL HOUSEKEEPING | 2021-02-26 09:18:53 | 2021-02-26 09:59:49
 | 2021-02-26 00:00:00 | [NAME] | OTHER: ASSISTING DEPARTMENTS | 2021-02-26 09:59:51 | 2021-02-26 12:45:58 |  |  |  |  |  |  |  |  |  |  |  |  | superior fire JW
 | 2021-02-26 00:00:00 | [NAME] | PREPARING PALLETS | 2021-02-26 10:00:37 | 2021-02-26 17:58:00
 | 2021-02-26 00:00:00 | [NAME] | PREPARING PALLETS | 2021-02-26 10:28:08 | 2021-02-26 14:00:59
 | 2021-02-26 00:00:00 | [NAME] | ACTIVITIES: HEALTH SENTENCE | 2021-02-26 09:18:36 | 2021-02-26 10:28:08 |  |  |  |  |  |  |  |  |  |  |  |  | 1 pallet removed 1 delivered
 | 2021-02-26 00:00:00 | [NAME] | GENERAL HOUSEKEEPING | 2021-02-26 10:31:24 | 2021-02-26 14:20:02 |  |  |  |  |  |  |  |  |  |  |  |  | shelving with mouldy boxes in container 111 boxes
 | 2021-02-26 00:00:00 | [NAME] | GENERAL HOUSEKEEPING | 2021-02-26 10:31:25 | 2021-02-26 14:20:04 |  |  |  |  |  |  |  |  |  |  |  |  | shelving with mouldy boxes in container 111 boxes
 | 2021-02-26 00:00:00 | [NAME] | PREPARING PALLETS | 2021-02-26 10:31:25 | 2021-02-26 17:58:04
 | 2021-02-26 00:00:00 | [NAME] | PUT AWAY CONTAINERS: ONSITE | 2021-02-26 11:00:06 | 2021-02-26 14:59:17