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