Calculate Time difference for every day

Timste — Wed, 29 Sep 2021 15:39:21 GMT

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

topic Calculate Time difference for every day in QlikView