Time and Date/Time Formulae

[xunzi]

Hi

I know this is going to be an easy one but here goes:

I am summing hours and comparing but one group is time and the other is date and time. e.g.:

12:00

01/01/1900 7:27:00 AM

 

[NBVC]

I think it's just a formatting issue. Select Cells from the Format menu and from the Number tab, select Time and choose the format from the right side.

 

[Brian from Maui]

I'm assuming the answer is 19:27. A simple A1+B1 and custom format the cell that houses the formula as [h]:mm

 

[xunzi]

This doesn't work when minusing the date and time data from the time-only data.

 

[fairwinds]

Hi,

Try:

=MOD(B1,1)-MOD(A1,1)+(MOD(B1,1) < MOD(A1,1))

 

[barry houdini]

This doesn't work when minusing the date and time data from the time-only data.

....so for your example above, what result do you expect?