NOW() function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
As you say, NOW() will always be greater than 16:00, so the reason that the
OP was getting FALSE is that the quotes around the times make them text
strings.
If you use double unary minus, that will convert them back to times [as an
alternative to using the TIME() function], so try
=AND(MOD(NOW(),1)>--"16:00",$DR$3<--"16:00")
 
Back
Top