Difference in time between Dates

[skashat]

Hello,

Thank you in advance to anyone who can offer help...


I have two columns of data; one is a start time and the other is an end time.

The start time will show something like this 23:40, which obviously means 11:40 PM. And an end time may show 23:45.

I can calculate the difference between the two by saying (End Time - Start Time)*60*24 = Total minutes to complete.

However, this formula does not work for jobs that go beyond 24:00.

I may have instances where the start time is 23:40 but the end time is 01:40.

Can I make a formula that would give me 3 hours (180 minutes) for these types of instances?

 

[VoG]

That time difference is actually 2 hours. Try like this

Excel Workbook
	A	B	C
1	23:40	01:40	02:00
Sheet1

 

[T. Valko]

Hello,

Thank you in advance to anyone who can offer help...


I have two columns of data; one is a start time and the other is an end time.

The start time will show something like this 23:40, which obviously means 11:40 PM. And an end time may show 23:45.

I can calculate the difference between the two by saying (End Time - Start Time)*60*24 = Total minutes to complete.

However, this formula does not work for jobs that go beyond 24:00.

I may have instances where the start time is 23:40 but the end time is 01:40.

Can I make a formula that would give me 3 hours (180 minutes) for these types of instances?

As long as the difference will not be greater than or equal to 1 day...

A1 = start time = 7:00 PM
B1 = end time = 3:00 AM

=MOD(B1-A1,1)*24

Format as General or Number

If the time may span multiple days then you'd have to include the dates with the calculation and then it would be simple subtraction.

 

[skashat]

Yes!

Thank you both for the extremely quick responses.

@ T. Valko, yes you're right I do have to make the assumption that it never goes beyond a day (I am given only a start date).

@VoG, good catch on the number of hours

Thank you both again, you have made my life (at least somewhat...) easier -_-

 

[T. Valko]

Yes!

Thank you both for the extremely quick responses.

@ T. Valko, yes you're right I do have to make the assumption that it never goes beyond a day (I am given only a start date).

@VoG, good catch on the number of hours

Thank you both again, you have made my life (at least somewhat...) easier -_-

You're welcome. Thanks for the feedback!