A formula for certain time intervals

Originally Posted by TudyBTH

Hi,
Try this

Formula:

=TEXT(INDEX($K$2:$K$6,IFERROR(MATCH(B2,$K$2:$K$6,1),5)),"HH:MM")&"-"&TEXT(INDEX($L$2:$L$6,IFERROR(MATCH(B2,$K$2:$K$6,1),5)),"HH:MM")

It has created a list of the time intervals (K1:L6)
Attachment 477256
see attached

Hi Tudy,

That works a charm.

Many thanks for providing the formula. Much appreciated.

Thanks,
Has