4 Weel Rota/ i month Timesheet

[lizard99]

Hi

I am struggling with a problem and I wonder if any of you good people can help.

- Our employees all work a rolling 4 week shift pattern so each week they do a different amount of hours.
- All of the employees shift patterns are different.
- Our employees have to complete a calendar month timesheet which then gets forwarded to payroll to get paid.

Our employees currently get given a blank timesheet to complete every month but some of them get it wrong. To combat this what I would like to do is to put their timesheet on a worksheet for each employee and that the worksheet be able to work out what their work pattern is on each given month. As they work the 4 week shift pattern and the timesheet is per calendar month I have not worked out how we can do this. Have any of you guys got any ideas?

Thanks for your help

[estratosphere]

Lizard, firstly welcome to the forum!

Could you have a hidden worksheet that has the entire calendar year by day, with the shift that will take place on that date and then on the Calendar Month timecard lookup the shifts?

[lizard99]

many thanks Estratosphere that is certainly one to consider. Would there be a way for each months new timesheet to automtically pick up the correct work pattern from the yearly calendar or would I need 12 timesheets per employee?

Once again thanks for looking at my problem.

[estratosphere]

Yes you could use a simple lookup to determine the month and it would pick up the correct shifts

[lizard99]

I'll give it a try. Thanks for the help, much appreciated.