Calculating number of hours greater than 24 hours

[colleen8580]

Hi,

I need to calculate the number of hours occuring between two times. Some of the times occur within 24 hours of each other and some occur greater than 24 hours apart. On the sheet is listed the date in, time in date out time out. I have figured out how to make the calculation if the time out occurs within 24 hours of the time in. However I do not get a correct calculation if the times are greater than 24 hours apart. Is there a way to calculate both correctly.

[DonkeyOte]

It's not clear from your explanation if the date & time values are one cell or are in fact separate cells (ie Date in cell A, Time in cell B etc...)

Assuming DateTime values, In Col A, Out Col B then to get total time passed:

C1: =B1-A1
formatted to [hh]:mm

If on the other hand Date In is Col A, Time In is Col B, Date Out is in Col C, Time Out is in Col D then to get total time passed:

C1: =SUM(C1:D1)-SUM(A1:B1)
formatted to [hh]:mm