Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel shift table
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 -- voidmain ------------------------------------------------------------------------ voidmain's Profile: http://www.excelforum.com/member.php...o&userid=28833 View this thread: http://www.excelforum.com/showthread...hreadid=487872 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel shift table
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking table in Excel to word | Links and Linking in Excel | |||
Pivot Table Memory Issue - Excel crashes | Excel Discussion (Misc queries) | |||
Table copied from Excel to powerpoint print all bold? | Excel Worksheet Functions | |||
Word table exported to Excel | Excel Discussion (Misc queries) | |||
Excel XP Pivot Table in Excel 2000 | Excel Discussion (Misc queries) |