Formula to pull one Clock in and One clock Out time when multiple exist for an individual

Good Morning -

I'm attaching a spreadsheet with fake data to show what I am looking for. I have individuals with multiple clock in and clock out times on a spreadsheet. I'm trying to create a sheet that summarizes this data. If John Doe Clocks in and out 4 separate times, I just want to say John Doe started at 8 AM and clocked out at 4PM avoiding the other times in and out that are in between. Please see attached sheet for a better explanation. Any help that can be provided is greatly appreciated. Thanks so much everyone!

MR22

In C19

=MIN(IF(($B$4:$B$13=$B19)*(C$4:C$13),C$4:C$13))

in D19

=MAX(IF(($B$4:$B$13=$B19)*(D$4:D$13),D$4:D$13))

Enter both ..

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Copy down

JohnTopley - This is EXACTLY what I was looking for! Thank you so much!

Could I take this one step Farther? You matched up name to name and brought back the min and max time. This is great. But now say some times have an A next to them and some times have a B next to them. I want the min and max time for doe "A" and then the min and max time for doe "B". Let me know if this is too confusing?

Thanks!