Hi, I am trying to put together a new staff rota on Excel and I am at my wits end, PLEASE HELP!!
I have four staff members, who I need to work between 9am - 6pm, Sun to Thursday I only need 2 of those staff on, Fri and Sat I need 3 Staff on but working the same hours. Each Staff Member needs to work 32 hours per week.
I am trying to be fair so everyone gets a turn at weekend etc, can anyone please advise?? - I just cant get to grips with formulas!!
Hi and welcome to the forum.
It's not really an Excel problem as such although Excel does lend itself very easily to such a project. Mathematically, it's quite a problem as you are already aware.
Attached is something that I have done mainly through trial and error if the truth be told. I've tried to be as faithful to your requirements as possible. If there are only two staff on Sun to Thurs you will have to put up with only one being available whilst the other takes a lunch break. To fit everything in and give as much cover as possible I've had to set it at a four day week of eight hours each. What I propose is that you rotate your staff members through this to make it equal. They may like it having three days off.
See what you think.
Cheers
Russell
Ignore the sheet2
If I helped, please don't forget to add to my reputation. (click on the star below the post)
If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.
Failure is not falling down but refusing to get up.
Thank you Russell - I will give it a swizz!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks