Here is what I am trying to do.

I am trying to find if a number falls between two different times can the result show the shift.

Reference
Shift1=0600-1400
Shift2=1400-2200
Shift3= 2200-0600

A B
Hour Result
17 Shift2
06 Shift1