creating a staff rota for 24 hour shifts

Good Afternoon Guy And Girls!

I am looking for some help regarding staff rotas and possible use of microsoft access or excel! i have self taught knowledge of both programs.
my partner is in charge of creating the staff rotas at work and they seem to be taking up alot of time, so i am wondering if there is a way i could help out by creating a spreadsheet that would auto fill staff into the days etc..

the problem that exists is that there are 6 staff in total, 5 staff are contracted to 10 x 24 hour shifts a month 1 staff contracted to 5 shifts, one of the full timers is not allowed to work with the part time staff! there has to be 2 staff on at all times!

if any one could shed any light on a way around this it would be of major help as it would free up alot of time that is currently wasted trying to do it manually!

i understand this is a big ask!! but any help would amazing!!

thanks
rob

So we talk Excel here and this certainly can be done but is there any way you can upload an example of your spreadsheet and the desired result. Threads with uploads get better responses and results than those without.

Hi ursul,

thanks for your response, i have not yet setup a spreadsheet at the moment i am currently working on it, i will have a look at the excel rota templates as they look like a great starting point, i am looking at the 24-48 fixed schedule at the moment. i basically need the template to issue two staff for each 24 hour shift i know there is shifts that will need covering with overtime or stand in staff! but is there anyway i can get this template to generate a rota that will ensure that no staff are working two days consecutive and also the the part time staff and another full time member of staff are unable to work together due to the nature of the work. this is a massive puzzle i am setting myself up for but if i means i am getting more time with my other half i am willing to put in the time to sort it! any pointers would be amazing

thanks rob

Hi Rob,

Once you get the basics sorted we can sort out the complications like who works with whom and have formulas that will alert you if something is not right or someone doing 2 shifts etc.

Cheers