time ,intervals

[woundedcrane]

COLUMN 1 COLUMN 2
17:40 0:00 -3:00
7:05 3:00- 6:00
6:35 6:00-9:00
19:05 9:00-12:00
6:25 12:00-15:00
15:00-18:00
18:25 18:00-21:00
18:25 21:00-00:00
hello everyone ,
I am new here and looking for help
IN the column 1 i have actual time
In column 2 i have i have time intervals
what i really want to do is based on time in cell a1 = 17:40 read column 2 find the interval that belongs to
and in a third column take the result 15:00-18:00
i tried with vlookup command but i didnt manage to make a1 read the interval
any help will be much appreciated
thanks a lot

[FlameRetired]

Is something like this what you had in mind?

Columns H and I are lookup tables. The formulas and their returns in columns D and E are the end results of the formulas
in column K of this segment. They are both essentially the same formula. One uses the lookup table the other has the values hard coded into it.

Row\Col	A	B	C	D	E	F	G	H	I	J	K
1	Start times			Intervals				Lookup values	Return values
2	17:40	0:00	3:00	15:00-18:00	15:00-18:00			0:00	0:00-3:00		D2 = LOOKUP($A2,$H$2:$H$9,$I$2:$I$9)
3	7:05	3:00	6:00	6:00-9:00	6:00-9:00			3:00	3:00-6:00		E2 = LOOKUP($A2,{0;0.125;0.25;0.375;0.5;0.625;0.75;0.875},{"0:00-3:00";"3:00-6:00";"6:00-9:00";"9:00-12:00";"12:00-15:00";"15:00-18:00";"18:00-21:00";"21:00-0:00"})
4	6:35	6:00	9:00	6:00-9:00	6:00-9:00			6:00	6:00-9:00
5	19:05	9:00	12:00	18:00-21:00	18:00-21:00			9:00	9:00-12:00
6	6:25	12:00	15:00	6:00-9:00	6:00-9:00			12:00	12:00-15:00
7	15:00	18:00	18:00	15:00-18:00	15:00-18:00			15:00	15:00-18:00
8	18:25	18:00	21:00	18:00-21:00	18:00-21:00			18:00	18:00-21:00
9	18:25	21:00	0:00	18:00-21:00	18:00-21:00			21:00	21:00-0:00
10

Is this what you meant?