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

You could put the CSE formulas:

=MIN(IF((B1:B6="Mike"), A1:A6))
in one cell (returns 8:00) and

=MAX(A1:A6*(B1:B6="Mike"))
in another (returns 10:00)

both these should be entered with Ctrl-Shift-Enter (Cmd+Return for Mac)