Providng range start value and end value where all values are the same

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!

Thanks! This is fantastic,
It helped me determine that I have another problem:
I keep getting the return "15:00" when using just the min or max components of the function you provided.

It may be because
- this is the mid-point between the hour schedule (07:00 - 00:00)
- the results are calculated values from a separate worksheet (ie. A='CW35'!$U9)
- while text is hidden in the table(using ";;;" formatting), if unhidden, the value "0" appears

Is there any way to overcome this?

Also, the max function on its own is not working (#REF!) in this scenario.
=TEXT(INDEX(A9:A26,MIN(IF(ISTEXT(C9:C26),ROW(C9:C26)))),"hh:mm")&""
=TEXT(INDEX(A9:A26,MAX(IF(ISTEXT(C9:C26),ROW(C9:C26)))),"hh:mm")&""
ShowGraphicalView.jpg
UnhideTextView.jpg

Thanks! That worked.
Changing status of the thread to solved.
Thanks to both benishiryo and mikerickson!

After these statements, I additionally needed to format the cells with these formulas to the custom format hh:mm, and then just supplant the "Mike" with whatever other name I needed to.

benishiryo -- if you like for interests' sake I can add the sample spreadsheet. Thanks again.

...or...
I could be a total nut and forgot to properly confirm the 'shift end' times.
The start times are great,
and technically the end times work too....except I need them to 'go up to' the next hour, not include the last hour.
For example, a shift goes from 16:00 to 01:00 -- Each cell with "mike" represents an hour served, so that means I would only put the value "mike" in cells adjacent to 16:00 to 00:00 (midnight).

I've attached a sample spreadsheet as example.
ShiftEndSample.xlsx

Awesome.