Multiple time ranges

[J.W. Aldridge]

I am trying to create a formula that will look up the time values and
return a letter.
Times are in column F.
Must include seconds (as values does include seconds).

07:00:00 - 17:30:00 = "A"
17:31:00 - 00:30:00 = "B"
00:31:00 - 06:59:00 = "C"

 

[Niek Otten]

<as values does include seconds).>

But you miss out whole minutes in your specications.
Anyway, this should work, but do check your threshold values. Maybe you need
to add a second or less than a second.

Set up a table like this (in this example: A1:B4)

0:00:00 B
0:30:00 C
7:00:00 A
17:30:00 B

With your time to look up in C1:

=VLOOKUP(C1;$A$1:$B$4;2)