hopefully somebody will be able to help me with the below;

00:00 | 00:30 | 01:00 | 01:30 | 02:00 | 02:30 | 03:00 | 03:30 | 04:00 | 04:30 | 05:00 | 05:30 | 06:00 | 06:30 | 07:00 |

2 | 5 | 6 | 6 | 8 | 8 | 7 | 9 |

<TBODY>

</TBODY>

The below formula will return the value of the first non blank cell in row 2:

=INDEX($A$1:$O$1,MATCH(TRUE,INDEX(($A2:$O2<>0),0),0)) Result: 01:00

The next formula returns he last non blank cell in row 2:

=LOOKUP(9.999999999E+307,$A2:$O2,$A$1:$O$1) Result: 06:00

I am looking for the start and end time of the first range and the start and end time of the second range.

Which formulas do I need to use to get

01:00-02:30 and 04:30-06:00.

any help is very much appreciated.

Bert.