Multiple time ranges

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

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"
 
<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)
 
Back
Top