Setting up function is 1am between 8a-8p or between 8p-8a?
 

If you have a column of time 1:00, 1:02, 6:23, 15:24, etc....and you want a
formula to tell you if B2(1:02) is between 8:00 and 20:00 then it is day and
if B2 is between 20:00 and 8:00 then it is night.

This is what I have but it doesn't work....I'm off somewhere...it doesnt'
always work correctly.
=IF((B23B27:B23<B26), "day","night") In this case B27 is the 8am time and
B26 is the 8pm time.

Setting up function is 1am between 8a-8p or between 8p-8a?
 

=IF(AND(A1=$B$27,A1<=$B$26),"day","night")

HTH
--
AP

"Rita" a écrit dans le message de news:
...
If you have a column of time 1:00, 1:02, 6:23, 15:24, etc....and you want
a
formula to tell you if B2(1:02) is between 8:00 and 20:00 then it is day
and
if B2 is between 20:00 and 8:00 then it is night.

This is what I have but it doesn't work....I'm off somewhere...it doesnt'
always work correctly.
=IF((B23B27:B23<B26), "day","night") In this case B27 is the 8am time
and
B26 is the 8pm time.