Hi All,
I have a data given below screenshot.
ID | StartDateUTC | EndDateUTC | IPAddress | ReasonCode |
95634D78-64CE-43B3-B430-0926A9DEDEA5 | 07-06-2021 15:27 | 07-06-2021 20:28 | 10.22.33.70 | 112 |
The requirement is have to take time difference between StartDate and EndDate field. The overall time diff is 5:0:10.
I have to split the data like this:
StartTime | EndTime | Downtime in Mins |
00:00 | 01:00 | 0 |
01:00 | 02:00 | 0 |
02:00 | 03:00 | 0 |
03:00 | 04:00 | 0 |
04:00 | 05:00 | 0 |
05:00 | 06:00 | 0 |
06:00 | 07:00 | 0 |
07:00 | 08:00 | 0 |
08:00 | 09:00 | 0 |
09:00 | 10:00 | 0 |
10:00 | 11:00 | 0 |
11:00 | 12:00 | 0 |
12:00 | 13:00 | 0 |
13:00 | 14:00 | 0 |
14:00 | 15:00 | 0 |
15:00 | 16:00 | 33 |
16:00 | 17:00 | 60 |
17:00 | 18:00 | 60 |
18:00 | 19:00 | 60 |
19:00 | 20:00 | 60 |
20:00 | 21:00 | 32 |
21:00 | 22:00 | 0 |
22:00 | 23:00 | 0 |
23:00 | 00:00 | 0 |
Thanks in advance. @MayilVahanan @sunny_talwar @marcus_sommer
Regards,
Dinesh.