Excel and time attendance resolving how many time user was IN and OUT

Hi Sasa,

pls find attached solution with the help of pivot table.

we cant track each time user spent time inside because , use has not swipe in or out properly, there are only 5 transactions can be track his spending time in office highlighted in yellow