Sir,
please help to resolve the following issue.
Data look like below
Required output like below
please help to resolve the following issue.
Data look like below
Date | Start Time | End Time | Value |
10-04-2018 | 06:30 | 09:40 | 13 |
10-04-2018 | 09:41 | 10:40 | 61 |
11-04-2018 | 10:50 | 11:40 | 30 |
12-04-2018 | 11:41 | 12:50 | 41 |
12-04-2018 | 12:51 | 14:40 | 32 |
11-04-2018 | 14:41 | 15:40 | 79 |
Required output like below
Date | Time | Value |
10-04-2018 | 07:30 | 13 |
10-04-2018 | 08:30 | 13 |
11-04-2018 | 10:55 | 30 |
11-04-2018 | 11:00 | 30 |
11-04-2018 | 11:35 | 30 |