TimeSpans -Splitting Hours

[NOTTINGHAM8]

New Member - first time post -

Hello all,

Does anybody know how to calculate the following-

(A1)Start 25/11/2018 17:00 (B1) Finish 26/11/2018 10:00 - Total Elapesed Time = B1-A1 = 17 HRS


The elapsed time between the start and finish is 17 hrs - however is is split over two days

What I want to calculate is the elapsed time on 25/11 = 7 hours and 26/11 = 10 hours.

The other criteria is I only need to calculate this where the start and finish times are on different dates

Any help would be greatly appreciated.

Best regards

John

 

[etaf]

how do you want to display the result
in 2 cells - what if more than 2 days
you can use an INT(date) and take 1 from the other than if zero - its 1 day
if 1 its 2 days - and then you could use midnight on 1st day and subtract start date
then you could use finish date and subtract midnight on 1st day