IF and TIME, hopefully an easy one

[LOH123]

Hi All,

Hoping this is easy for all you experts out there.

Im trying to do an IF statement based on a difference in time, I have entered =TEXT(Late time-Early time),"h") so that the time difference is displyed in hours only, hours and minutes is preferable but I can see no way of doing that. However, even with just hours it's not workng as I would hope. My IF statement is looking at that cell for a value over 5 IF(Cell>5,10,5) but even when the cell says 3 it is returning 10. I assume this is because it is time but don't know how to get round it. I have tried IF(Cell>TIME(5,0,0),10,5) but that doesn't work either, can you help?

 

[Scott T]

Text turns your number into text a number 7 does not = a text 7. you can add 0 to turn it back to a number.

=IF(A10+0>5,10,5)

 

[LOH123]

Thank you! I knew it would be easy I just didn’t know how to do it. Worked perfectly ?