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

[Guest]

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((B23>B27:B23<B26), "day","night") In this case B27 is the 8am time and
B26 is the 8pm time.

 

[Ardus Petus]

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

HTH