IF Statement finding the value between two times

[Acousticlife81]

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

[ChemistB]

With shift in E2:E5 and Start time in F2:F5

With Hour in A2, in B2 copied down

=INDEX($E$2:$E$5, MATCH(A2/24, $F$2:$F$5))