Thread: IF Function

Hey,

I was just wondering if anyone could help me with this IF Function formula,(I think its a IF Function)
I have in coloum E2 which is a set of times all the way down to E1630, I need to be able to find all the times which are After 18:00:00 and before 09:00:00,

I was just wondering if anyone could give me a hand

Thanks

I'm, not sure how you want to identify the cells, but this should get you started with an IF formula.

If you type this formula into cell F2 and copy it to all cells in column F that are to the right of a cell with a time, it will return "early" if the time is before 9am and "late" if the time is after 6pm.

=IF((E2-INT(E2))<9/24,"early",IF(E2-INT(E2)>18/24,"late",""))

Nicky C Thanks for your help, Spot on