Time vs. shift

[scolodny]

I am pulling in data to my spreadsheet from an external source. I have used NOW() and defined its format as military time. I am wanting to determine, based on that time, what shift I am currently in. Shifts are 7 - 2, 2 - 11, and 11 to 7. I have been playing this for awhile with no luck. Can anyone provide a resolution?

 

[PawPawGary]

Here's one way to accomplish what you want:
Change the cell where you have NOW() formatted as military time to =TIME(HOUR(NOW()),MINUTE(NOW()),0) and define this cell as TEST.
Create four defined Names as follows:
ATIME defined as =TIME(19,0,0)
BTIME defined as =TIME(2,0,0)
CTIME defined as =TIME(11,0,0)

In the cell where you want the shift to be displayed enter this formula:
=IF(OR(test>atime,test<=btime),"Shift A",IF(AND(test>btime,test<=ctime),"Shift B","Shift C"))

This assumes that the shift begins after 7:00 and ends on or before 2:00 (14:00).

Hope this helps,
Gary