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?