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
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
3,779
Office Version
365
Platform
MacOS
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
 

Watch MrExcel Video

Forum statistics

Threads
1,099,029
Messages
5,466,116
Members
406,467
Latest member
bpat83

This Week's Hot Topics

Top