I need to get a Value Based on Start time.

If the Start time is between 7:00 and 14:59 = First
If the Start time is between 15:00 and 21:59 = Second
If the Start time is between 22:00 and 6:59 = Third
Values will show in Column "D"
A B C D
1 Name Start End Shift
2 John Doe 8:00 17:00 Value?

Any help.