IF/Then with Time

[SdavisCBN]

I am looking to write a formula that states:

If greater than 12:00 PM then Shift 1
If 12:01PM-5PM than Shift 2
If 5:01PM-11:59PM than Shift 3

Thank you

[6StringJazzer]

="Shift "&LOOKUP(A1,{0,0.5,0.708333},{1,2,3})

Let me know if this is too cryptic for you. 0.5 means 12:00 noon and 0.708333 means 5:00 PM.

[6StringJazzer]

BTW I'm pretty sure you meant


If less than or equal to than 12:00 PM then Shift 1
If 12:01PM-5PM than Shift 2
If 5:01PM-11:59PM than Shift 3