Hello,
i have been struggling with this issue but cannot resolve it,hope someone could help me with this.
I have access control wich has export to excel .
In this exported table there are some fields like user name , time , IN (user goes in the office) , OUT (user goes out of the office) .
I was trying to calculate time user has spent (IN) inside office for specified time range.
Here is attached output from access control.
https://www.dropbox.com/s/78eej443j7qwwns/Swipe Records.xls?m
i have been struggling with this issue but cannot resolve it,hope someone could help me with this.
I have access control wich has export to excel .
In this exported table there are some fields like user name , time , IN (user goes in the office) , OUT (user goes out of the office) .
I was trying to calculate time user has spent (IN) inside office for specified time range.
Here is attached output from access control.
https://www.dropbox.com/s/78eej443j7qwwns/Swipe Records.xls?m
