| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Employee schedule
What I am trying to do is automate our shift schedules for our mechanics.
The layout is as follows, going down now to the right. Date mechanic1 Mechanic 2 etc. Jan1 X Off Jan2 X Off Jan3 off off I would like to enter the number of shifts Example 10 on 4 off 10 x, s down 4 off down. We have 4 different shifts, I tried if statement but having issues. If last 10 = x then off, If last 4=off then x. Thank for the help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Employee schedule
Have you had a look at Solver in the addins pack. They give you an example
of shift schedules that might help. -- John MOS Master Instructor Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Ralph" wrote: What I am trying to do is automate our shift schedules for our mechanics. The layout is as follows, going down now to the right. Date mechanic1 Mechanic 2 etc. Jan1 X Off Jan2 X Off Jan3 off off I would like to enter the number of shifts Example 10 on 4 off 10 x, s down 4 off down. We have 4 different shifts, I tried if statement but having issues. If last 10 = x then off, If last 4=off then x. Thank for the help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| employee schedule | Excel Discussion (Misc queries) | |||
| creating an advanced employee schedule | New Users to Excel | |||
| Employee Work Schedule | Excel Discussion (Misc queries) | |||
| Change formula for Employee Shift Schedule template | Excel Worksheet Functions | |||
| Referencing a newly created worksheet | Excel Worksheet Functions | |||
Linear Mode
