Elapsed time over date range

[REDDOG]

Please could someone tell me how it is possible to calculate the following.

Attached details Start and Finish times of transactions over different time ranges.

I need to calculate the elapsed time for each day for each transaction.

For example -

Transaction 1 =
Finish Date/Time 27/11/2018 10:00 - Start Date Time -27/11/2018 06:00

Equals - 4 hours

Transaction 2

Finish Date/Time 27/11/2018 10:00 - Start Date Time -26/11/2018 06:00

Equals - 28 hours

What I want to return is

26/11/18 = 18 hours and 27/11/18 = 10 hours

ie: The elapsed time per day(date)

Many thanks

REDDOG

 

[vletm]

REDDOG
Did You tried to search from forum? eg:
https://chandoo.org/forum/threads/separate-time-in-2-shifts.39574/