Hello, I need your help.
I have the following Dataset with a startdate + time and an enddate + time
example:
ID, start, end
333, 02.07.2021 12:20, 05.07.2021 16:20
334, 04.07.2021 12:20, 04.07.2021 14:00
What I need is a row for every day in this time interval and the difference between the start and end for each row like this:
ID, start, end, diff
333, 02.07.2021 12:20, 03.07.2021 00:00, 11:40
333, 03.07.2021 12:23, 04.07.2021 00:00, 24:00
333, 04.07.2021 00:00, 05.07.2021 16:20, 16:20
334, 04.07.2021 12:20, 04.07.2021 14:00, 01:40
Thank you