Create an excel macro
$10-30 USD
Paid on delivery
I have a spit out of timesheet from a fingerprint scanner. i would like to create a macro that automatically checks for errors and calculate the total hours worked everyday. this macro should spit out the total hours worked in the same template as the current shown file (timecard).
there will be time where my employee missed to scan his fingerprint (time in missing or time out missing). the macro needs to pick up on these and push out an error report to show all missing data so it can be manually filled in.
this macro should have a section where I can define the overtime rate.
public holiday = x 2 (able to put in which date is a public holiday)
weekends = x 2
weekdays = from 4pm to 6pm x 1.5, from 6pm onwards x 2
this macro should have a section where i can define breaktime
1hr break between 7am to 4pm
0.5hr break between 4pm to 6pm
See attached reports extracted
Project ID: #36851433
About the project
33 freelancers are bidding on average $36 for this job
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look More
Hi There Nice to knoe your requirement Have delivered more than two hundred Excel VBA Macro projects in the last six years Willing to discuss and work with you on this. Thank you
Hello There, I can do this fast. This a piece of cake to me. Lets chat to discuss deadline You can visit my Profile
Hi, I have great data entry skills. I will provide you best and accurate service with complete satisfaction.
Hi, I can develop Excel VBA Macro as per your requirements. I am an experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to More
More than 10 years of experience in VBA. Instant solution within hrs. I have a lot of projects under my belt.
Greetings, I am an Advanced Level Excel Formula, VBA & Macros expert and an Accountant. I am very confident to start your project and complete it with all efficiency you are looking for. I understand the requirements a More
Hi there myself yesu I am a vba developer I can do this you can contact me on this for further discussion thanks
Greetings For the Day! I have 12 years of experience in the Automation, Development & Visualization and I am providing services related to my skills with great quality. Created many projects ranging from auto Email, More
Good day, I've complete Phd Software Engineering. I've 5-Year experience in Java development and algorithm implementation. My Core Expertise in Java - C++ - C - object-oriented - Data Structure - Swing - OpenGL - Java More
Hey sir, it seems that you want to create a macro that allows you to track the sign-in for employees using fingerprints. You want to track the total worked hours, figure out missing sign-in or out, and also want to cal More
Hello, thank you for considering me for this project. I understand that you are looking for someone to create an Excel Macro that checks for errors and calculates the total hours worked everyday. This macro should spit More
i am a expert data analyst and excel expert as well, i have done many similar projects , such as AXS 200 excel dow 30 excel and many stock market excels , i can do it in a day for you lets talk.
Hello, I am interested in your project and i can complete it within required time. I have appropriate experience in Microsoft Office Products(Word, Excel, PowerPoint, Visio, Project as well as VBA etc) of more than 10 More
Hi I am fully expert in data entry and Ms office work I read your all requirements I will give you best work on your time and budget Until you get fully satisfied with work I keep my work I'm new on Freelancer bu More
Hello there! I am Miza, I understand that you are looking for someone to create an excel macro that can check for errors and calculate the total hours worked everyday. This macro should spit out the total hours worked More