Excel macro rota / timesheet
- or -
Post a project like this£250(approx. $312)
- Posted:
- Proposals: 6
- Remote
- #106830
- Expired
Design and Build Turnkey Data based business solutions and process streamlining for SME's
Birmingham
2258106656239493247501247694253533
Description
Experience Level: Expert
Hi,
Im not sure how to explain this properly -
Right now i need a way of checking employee hours - at the moment an employee would email their timesheet in excel, with the total hours at the bottom, this would then be checked against the monthly rota manually
the rota is also done in excel, with time blocks for example, 12pm-3pm shift, 3pm-6pm shift - the employee name is put into the block, so if they are in 12pm-3pm shift, on their timesheet it would say 3 hours for that date & time
We have alot of employees, so as you can imagine this takes a long time to check every single employees timesheet correctly, as we need to count up every hour they have worked on the rota - To complicate things, some shifts are split, for example, 12pm - 15.25 -
Is there anyone that can help with this? and if so , perhaps show an example so i know you understand the job?
Thanks
Im not sure how to explain this properly -
Right now i need a way of checking employee hours - at the moment an employee would email their timesheet in excel, with the total hours at the bottom, this would then be checked against the monthly rota manually
the rota is also done in excel, with time blocks for example, 12pm-3pm shift, 3pm-6pm shift - the employee name is put into the block, so if they are in 12pm-3pm shift, on their timesheet it would say 3 hours for that date & time
We have alot of employees, so as you can imagine this takes a long time to check every single employees timesheet correctly, as we need to count up every hour they have worked on the rota - To complicate things, some shifts are split, for example, 12pm - 15.25 -
Is there anyone that can help with this? and if so , perhaps show an example so i know you understand the job?
Thanks
David M.
100% (1)Projects Completed
3
Freelancers worked with
2
Projects awarded
20%
Last project
15 Jul 2015
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies