• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Login and Logout automation

Munawar

New Member
Dear Sir,

I Have an Excel sheet, in which there is data for swipe in and swipe out for employee. The data is in huge amount. due to that i have to spend lot of time on it. Is there any way where i can do some automation and get the below result easily.

Date#
Office in time#
Total time spend in Office#
Total time spend outside Office#
Final Office out time#
 

Attachments

  • swipein.xlsx
    272.5 KB · Views: 16
You will end up chasing rabbits with total time spent in office and out of office as the swipe logs of IN and OUT are not equal. But the Date, First In and Last Out can be determined correctly. Is that OK for you?
 
Hi,

I just want to know how many minutes employee has spent time in the office.
Hi,

The paste below is an extract from the data when the person exited 4 times with no intervening ENTRY events being recorded. How can this be? What do we deduce about where the person was at (say) 03:00?


Code:
8/30/2014 01:56:01Access grantedCAQ MAIN ENTRANCE_ENTRY
8/30/2014 02:31:57Access grantedCAQ MAIN ENTRANCE_EXIT
8/30/2014 02:38:10Access grantedCAQ MAIN ENTRANCE_EXIT
8/30/2014 03:02:11Access grantedCAQ MAIN ENTRANCE_EXIT
8/30/2014 03:02:14Access grantedCAQ MAIN ENTRANCE_EXIT
 
Hi
Thanks for your reply, now i have added employee names also. it will easy for you to identify. Initially i have not mentioned the employee name, so got confused. kindly find attached file
 

Attachments

  • swipein.xlsx
    372.5 KB · Views: 15
Back
Top