Sample Excel Format (Query)
A B C E E F
1 30/05/2020 Spc Sharon 06:07:06 06:25:44 00:18:38
2 30/05/2020 Spc Dublin 06:26:42 06:30:47 00:04:05
3 30/05/2020 Spc Rule 06:30:47 06:36:14 00:05:27
4 30/05/2020 Spc Tik 06:36:34 06:57:26 00:20:52
5 30/05/2020 Lead Local 06:57:44 07:18:08 00:20:24
6 01/06/2020 Lead Robin 06:21:29 06:26:11 00:04:42
7 01/06/2020 Lead Smith 06:26:11 06:30:12 00:04:01
8 01/06/2020 Spc Kris 06:30:12 06:35:22 00:05:10
9 01/06/2020 Spc Jasper 06:35:44 06:57:52 00:22:08
10 01/06/2020 Lead Local 06:58:33 07:22:35 00:24:02
11 01/06/2020 Lead Smith 07:27:05 07:45:50 00:18:45
Based on above data table how to fetch below data for column E (Array formula on multiple)
A B C D E
25 30/05/2020 06:30 07:00 Spc Rule / Tik
26 01/06/2020 07:00 07:30 Lead Local
27 01/06/2020 06:30 07:30 Spc Kris / Jasper
Need an array formula to fetch data in column E
Thanks
A B C E E F
1 30/05/2020 Spc Sharon 06:07:06 06:25:44 00:18:38
2 30/05/2020 Spc Dublin 06:26:42 06:30:47 00:04:05
3 30/05/2020 Spc Rule 06:30:47 06:36:14 00:05:27
4 30/05/2020 Spc Tik 06:36:34 06:57:26 00:20:52
5 30/05/2020 Lead Local 06:57:44 07:18:08 00:20:24
6 01/06/2020 Lead Robin 06:21:29 06:26:11 00:04:42
7 01/06/2020 Lead Smith 06:26:11 06:30:12 00:04:01
8 01/06/2020 Spc Kris 06:30:12 06:35:22 00:05:10
9 01/06/2020 Spc Jasper 06:35:44 06:57:52 00:22:08
10 01/06/2020 Lead Local 06:58:33 07:22:35 00:24:02
11 01/06/2020 Lead Smith 07:27:05 07:45:50 00:18:45
Based on above data table how to fetch below data for column E (Array formula on multiple)
A B C D E
25 30/05/2020 06:30 07:00 Spc Rule / Tik
26 01/06/2020 07:00 07:30 Lead Local
27 01/06/2020 06:30 07:30 Spc Kris / Jasper
Need an array formula to fetch data in column E
Thanks