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.