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

**amy_d2** · 08-21-2013, 02:49 AM

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

**sasa.bgd** · 08-21-2013, 03:01 AM

Hi Amy_d2 ,
first of all thank you for helping me with this,appreciate it.

Yes i have seen that user didnt swipe properly.
Here is another export with proper swipe.Swipe Records.xls
Also if user by mistake swipe two times is there a formula to somehow ignore and use one record?
Here is example:

Sale 12:15 in
Sale 12:22 exit
Sale 12:23 exit

Can we calculate last time (12:23 exit ) and ingore 12:22 time?

**sasa.bgd** · 08-21-2013, 03:06 AM

I have make an error in thread name...i do not need how many time user has ben inside and out....i need time spend in ,( how many time user has been inside office...2hour,4hour..etc..)