Hi There
We have a Fingerprint reader for our staff Time & Attendance. Attached the standard report from the device - untouched
Now in this report, it give a daily breakdown of the Employee Check IN, Breaks and Checkout
Check In - meaning when the user start work
Breaks - Off duty for tea or lunch breaks
Check out- Meaning when user finishes work
Now what I want, a VB marco script on the attachment below:
On the worksheet open, to prompt me, to upload the Standard_report (from the device excel worksheet)
Refer to: Att.log report TAB
Create each new tab with the Employee Number
And fill in the working times (as shown in example for Employee 7 and 23)
Thats it
Could you kindly do this formula VB scrip
Bookmarks