Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for a Rotating Work Schedule?
Hello. Does anyone know if Excel can be used to automatically create
a rotating work schedule for staff? We want 3 teams (for 3 shifts), with 7 people on each team. Each person will work standard hours (5 days on, then 2 days off), but their days will be staggered so that staff will be here every day. I have never seen a scheduling worksheet in Excel. Is this possible, or would another software application be better? Thanks, Jessi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for a Rotating Work Schedule?
An addendum...
Well, I was confused... staff will NOT always work 5 days on, then 2 days off. There could be ANY combination of work days, as long as the employee does not work more than 40 hours per week, and has off *a* Saturday and *a* Sunday at least every 3 weeks. Could Excel be used to automatically create a work schedule for a group of employees? Thanks, Jessi |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for a Rotating Work Schedule?
Obviously, you are not the first to have to deal with a shift schedule - so
There are all kinds of scheduling applications around (some may even be free). You might try to google to find some. I doubt a formula would be useful in this situation and setting up a spread sheet to do it would probably take a lot of work and not be very robust to boot. -- Regards, Tom Ogilvy wrote in message oups.com... An addendum... Well, I was confused... staff will NOT always work 5 days on, then 2 days off. There could be ANY combination of work days, as long as the employee does not work more than 40 hours per week, and has off *a* Saturday and *a* Sunday at least every 3 weeks. Could Excel be used to automatically create a work schedule for a group of employees? Thanks, Jessi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a rotating schedule | New Users to Excel | |||
3 hour rotating schedule | Excel Discussion (Misc queries) | |||
Creating a weekly rotating employee work schedule | Excel Discussion (Misc queries) | |||
Creating a Rotating Schedule | Excel Discussion (Misc queries) | |||
create work schedule in Excell (6employees rotating shifts) | Excel Worksheet Functions |