4 week schedule

[Sgt.Krutt]

Hello everybody

I am trying to make a partly automated work schedule in Excel but my head only explodes when I try. I have tried different methods but I am not able to figure this out.

I will try too explain what I am trying to do. The total workday is 7,5 hours, between 11:00-12:00 there should be a 30 minute break for lunch, the schedule is divided into half-hour's, each person should not have more than 1.5 hour shift continuously, and not less than 1 hour (each employee may have more than one shift a day) Within a 4 week plan there should be more or less an equal amount of half-hour's for each employee.

Each day I need a certain amount of People in each half-hour column. The number in need is listed in Sheet2 under each time period. The number in Sheet1 B17 shows how many for reference.

I will fill if there are any questions.

Best Regards

[JohnTopley]

Take a look here ...

http://wheniwork.com/blog/employee-s...xcel-template/


There are others if you "google" for "Excel work scheduling" or similar

[tim201110]

have you tried to google "work timetable soft"?
or
http://whentowork.com/