hi,
something like this might work...
=IF(C1B1,"Less","greater")
where C1 and B1 are times and C1 is the current time
this will work too....
=IF(NOW()B1,"Less","greater")
B1 would be the time and NOW() would be the current time and eliminates the
need for cell C1.

regards
FSt1

"Finks" wrote:

Is there a way to get Excel to check if the time entered in a cell (in the
format hh:mm) is less than the current time?
Cheers.