Hello!
I am trying to find a way to return a 'start' and 'end' value for a timesheet schedule I am creating. Any ideas would be welcome!

The values will always be 'like' in column2 if there is a value there at all. In the example, the value is "Mike"
I want it to reference columns 1 & 2 so that it returns a start time and end time as defined by column1.
In the example, I want it to return 08:00 - 10:00.
Alternatively, if I can have it return 08:00 in one cell and 10:00 in another cell.


07:00
08:00 Mike
09:00 Mike
10:00 Mike
11:00
12:00


Thanks in advance!