Hi all,

I have employee attendance file as follows (access card entry at different doors or may be in the same door multiple times in company premises)

I want to only consider in time (first entry) & out time (last entry)

Given example of one date. Please suggest formula for this.

Next date would be below this & same logic like this.

Local Time
7/3/2017 9:02:47 AM
7/3/2017 9:06:16 AM
7/3/2017 10:41:11 AM
7/3/2017 11:51:03 AM
7/3/2017 12:59:55 PM
7/3/2017 2:13:45 PM
7/3/2017 2:50:31 PM
7/3/2017 4:23:39 PM
7/3/2017 4:23:50 PM
7/3/2017 4:29:37 PM
7/3/2017 4:33:22 PM
7/3/2017 5:56:57 PM
7/3/2017 6:04:10 PM