between 2 different time

J

jinvictor

how to use "between" choose 2 different time?
sample: if 2000 is between 1800 and 0600 then true.

please help
 
B

Bob Phillips

=IF(AND(2000>=A1,2000<=A2),TRUE,FALSE)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top