If function with time

[ManonW.]

Hi all,

I have an Excel file with 7 diffrent times. I am looking for a formule to show the number under the time (see the attached file).

For example
If it is between 08:00 and 09:05 I want to show A3, if it is between 09:05 and 10:00 I want to show B3, if it is between 10:00 and 11:00 I want to show D3 and so on.

The 7 time frames are:
From 08:00 till 09:05 (show A3)
From 09:05 till 10:00 (show B3)
From 10:00 till 11:00 (show C3)
From 11:00 till 15:30 (show D3)
From 15:30 till 16:00 (show E3)
From 16:00 till 17:30 (show F3)
From 17:30 till 18:30 (show G3)

Is there anyone who can help me with this issue?

Regards,

Manon