Time greater than or less than

[csilabgirl]

Excel 2002

In cell D2 I have the formulaa =NOW() and its formated for time.

in cell E2 I have manually typed in 10:00 am and it also is formatted for time.

Presently cell D2 says 9:20 AM. In cell C2 I have a formula:

=IF(D2>E2,"You are adding samples after the cut-off time","")

But it does not work. No matter what time is it, it always answers True. It seems like this should be simple enough, but I am missing something.

I have run an =ISNUMBER(cell) on both cells and they both come back true.

Thank you for the help.

 

[VoG]

Try

=IF(MOD(D2,1)>E2,"You are adding samples after the cut-off time","")

 

[csilabgirl]

VoG,

Thank you that works. If you have a minute could you explain what the "MOD" is doing so that I can learn and then maybe find that it has use in other applications. If you dont have time, I understand.

Thank you

 

[VoG]

Now returns Date + Time (date = integer portion, time = decimal portion). Using MOD(Now(),1) returns just the decimal part = time.

 

[csilabgirl]

OK, I understand, thank you.