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.