Getting first "IN" and last "OUT" time in Work

[margerome13]

Hello Guys,

I hope you could help me. I have table with names and time in and time outs of our employees and the corresponding dates. The excel attachment is the MIS report of the biometrics. I want to get the first "IN" of a particular date, and the last out of a particular date range, and a particular employee name. Is there a formula where I can get only the first in and last out given the said scenario. The table at the right is where I want the answers to fill in with yellow filler.

Here is the link of the Excel File for more details: https://www.dropbox.com/s/nio63iku9xygg0z/Excel Formula Question.xlsx?dl=0

 

[oldbrewer]

		in	out	in	out	in	out
	fred	09:00	09:45	10:55	13:20	14:10	17:30
		the first in is the minimum of F10:K10
		the last out is the maximum
		09:00
		17:30
		I never download stuff on here so I have no
		idea if this is your requirement…

<colgroup><col width="64" span="9" style="width:48pt"> </colgroup><tbody>
</tbody>