First And Last Value

[Andy Teal]

i want first and last value(time) of a given date in two different columns
im able to get the first value through vlookup with a helper column, but have trouble with the last value

				Result
Helper Column	Name	Date	Time in/Out	First Value	Last Value
Young|45068	Young	22/05/2023	8.24.01	8.24.01	17.35.59
Young|45068	Young	22/05/2023	17.35.59
Young|45069	Young	23/05/2023	8.20.47	8.20.47	17.24.43
Young|45069	Young	23/05/2023	17.18.13
Young|45069	Young	23/05/2023	17.24.43

i have attached excel file, please provide solution for the above query.

 

[The_Doc_Man]

Please note that if the Excel sheet isn't sorted, First and Last have uncertain meanings. Min and Max are more certain in their meaning.