Time & Attendance Excel Worksheet

recharger

New Member
Joined
Jan 21, 2019
Messages
1
Hi There


We have a Fingerprint reader for our staff Time & Attendance. Attached the standard report from the device - untouched
https://www.excelforum.com/attachment.php?attachmentid=607220&stc=1&d=1548060569


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:
https://www.excelforum.com/attachment.php?attachmentid=607221&stc=1&d=1548060784


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
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Hi & welcome to MrExcel.
Cross posted https://www.excelforum.com/excel-pr...d-attendance-excel-worksheet.html#post5048119

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Also members here will not be able to download the files you have linked to, unless they are a member of ExcelForum as well.
 
Upvote 0

Forum statistics

Threads
1,213,549
Messages
6,114,264
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top