Excel shift table

[voidmain]

Hi,

I was wondering if it's possible to create an excel template to do the following.

I have 30+ employees working at a shop in a friend's company. He wants to create a template in excel to manage shift duties over a week. when the strength for a shift is given(for example, 8 people on monday morning shift), i want the duties be shared equally (not totally equally) among the staffs. lets say each employee is given a number like emp_Id. is it possible to create a shift timetable like this in excel?

ANy help, guides and directions are welcome.

Thanks

voidmain

[bob777]

You will need to assign people to the different shifts, eg morning, lates, nights according to their preferences but in general giving staff an equal share of good and bad shifts. You could use excel to display hours worked on each type of shift using bar charts. Most companies just rotate workers through the shifts and manage sickness and holidays. I feel you are requiring something else, perhaps you could clarify.