Data in column A to F, result in H to L column. Please help to find a solution through VBA or array formula which will concatenate Task by each person for specific date within start and end time. Pasted excel table for your view.
Date | Person | Task | Start | End | Time | Date | Start | End | Person | Task | |
30/05/2020 | Spc | Sharon | 06:07:06 | 06:25:44 | 00:18:38 | 30/05/2020 | 06:30 | 07:00 | Spc | Rule / Tik | |
30/05/2020 | Spc | Dublin | 06:26:42 | 06:30:47 | 00:04:05 | 01/06/2020 | 07:00 | 07:30 | Lead | Local | |
30/05/2020 | Spc | Rule | 06:30:47 | 06:36:14 | 00:05:27 | 01/06/2020 | 06:30 | 07:30 | Spc | Kris / Jasper | |
30/05/2020 | Spc | Tik | 06:36:34 | 06:57:26 | 00:20:52 | ||||||
30/05/2020 | Lead | Local | 06:57:44 | 07:18:08 | 00:20:24 | ||||||
01/06/2020 | Lead | Robin | 06:21:29 | 06:26:11 | 00:04:42 | ||||||
01/06/2020 | Lead | Smith | 06:26:11 | 06:30:12 | 00:04:01 | ||||||
01/06/2020 | Spc | Kris | 06:30:12 | 06:35:22 | 00:05:10 | ||||||
01/06/2020 | Spc | Jasper | 06:35:44 | 06:57:52 | 00:22:08 | ||||||
01/06/2020 | Lead | Local | 06:58:33 | 07:22:35 | 00:24:02 | ||||||
01/06/2020 | Lead | Smith | 07:27:05 | 07:45:50 | 00:18:45 |