Matching dates with different formats and multiple criteria

Hi,
I have this worksheet that I'm currently working on.
I need to compute for the overtime hours by the staff on a daily basis.
However, the data provided by our IT shows that some staff had multiple in and out per day. Thus, it's very difficult for me to get the no of hours worked if I have to check the in/out manually and one at a time - it would be very tedious and time consuming.
I wanted to do a vlookup or match however, the dates are in different formats.
How do I match the earliest time checked in and latest time checked out by a staff.
Attached is the worksheet.

Thank you in advance for the help!

To find earliest time for a given date

=INDEX($D$4:$D$100,SMALL(IF(INT($D$4:$D$100)=INT($D4),ROW($A$4:$A$100)-ROW($A$4)+1,""),1))

For latest time for same date

=INDEX($F$4:$F$100,LARGE(IF(INT($F$4:$F$100)=INT($F5),ROW($A$4:$A$100)-ROW($A$4)+1,""),1))

These array formulas and need to entered with CTRL+SHIFT+ENTER

Hope this helps.

The results are in columns AA and AB of the attached.

Hi John,

Thanks for the formula. It works just right. However, I need to refer the data from another sheet that lists all the in/out of all staff. Thus, how to modify the formula so that I could match the in/out timing with the corresponding staff?

Thanks again!

Can you post a sample file showing the sheets with in/out and your "summary" please.