TimeSpans -Splitting Hours

NOTTINGHAM8

New Member
Joined
Nov 26, 2018
Messages
1
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
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
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
 
Upvote 0

Forum statistics

Threads
1,213,485
Messages
6,113,931
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top