Visual Basic, Data matching
This project received 26 bids from talented freelancers with an average bid price of $157 USD.Get free quotes for a project like this
Project Budget$30 - $250 USD
Every two weeks I have to pull an attendance report. In this report we have the employees work date and work time. Please look at attendance 8-19-9-9 excel file.
With this file we open the second excel file. payroll9-8-13. We go to the data sheet and enter how many hours each person worked under which position they are assigned to. The three most important positions is Server Busser and Kitchen. We enter their hours and excel distributes the tips among our staff.
The need from the project is the eliminate the time we spend entering these numbers. So on attendance excel under employee named David, if it say he worked 3 hours 34 minutes lunch shift on 09/02/2013 then on payroll excel under data sheet it should put 3.6 (rounding up) for the shift David worked under that day.
I will give more details to explain the process.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online