Time range

[Luigi802]

I'm trying to make a cell automatically return what the current shift is, for example if it is between 7:00 am and 3:00 pm return 1st shift, between 3:00 pm and 11:00 pm 2nd shift and 11:00 pm to 7:00 am 3rd shift. All I want to see in the cell is 1st, 2nd or 3rd shift when it is within their prospective times.

 

[steve the fish]

Try:

=LOOKUP(MOD(NOW(),1),{0,7,15,23}/24,{"3rd Shift","1st Shift","2nd Shift","3rd Shift"})

Note 7am will show as 1st shift even though your example has it in both the 3rd and 1st shifts.

 

[Luigi802]

Thank you that worked perfectly!