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.


--
bob777
------------------------------------------------------------------------
bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504
View this thread: http://www.excelforum.com/showthread...hreadid=487872