NOW() returns both the date (as the integer part) and time (as the
fractional part), so unless your system clock is set to 12/31/1899 (or
1/1/1904 in the 1904 system), NOW() will *always* return a value
"16:00" (which gets converted to 0.666666666666667, since 16:00 is 2/3
of 1 day).

Perhaps:

=AND(MOD(NOW(),1)TIME(16,0,0), $DR$3<TIME(16,0,0))

which strips off the date part of NOW() will work for you.


In article ,
nastech wrote:

not seeing what missing, trying to make the following:

=AND(NOW()"16:00",$DR$3<"16:00")

where Now()"16:00" seems to return the opposite of the actual time.
if 17:00 is the time, I get a FALSE. is there an error in my example?
thanks