How do I reference a column of time that spands multiple days against a static range?

There is more data removed from the workbook attached for simplicity sake, but I can't figure out how to have column D look at the same row and determine if column A, for that row, falls within the Time Range table and places the appropriate shift in column D. So for example, D4 would look at A4 then see what range (F2:G4) that falls between and returns the corresponding cell from column H.

I tried doing an index, but I was running into an issue with 3rd shift just kept continuing. I think it is because the date in the background of the cell changed.

These times on this sheet will be adjusted often, but consecutive. I need the sheet to display what shift each start time falls on.

I also tried converting time to a decimal and that also just kept continually added up and didn't reset.

Any help would greatly be appreciated.

Thanks

One way to do it.
Split 3rd shift into two part.

Then use something like below.
=INDEX($H$2:$H$5,LOOKUP(MOD(A4,1),$F$2:$F$5,{1,2,3,4}))

See attached.

Edit: Oh wait. Index portion isn't needed... doh.
=LOOKUP(MOD(A4,1),$F$2:$F$5,$H$2:$H$5)