ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Formula for a Rotating Work Schedule? (https://www.excelbanter.com/excel-programming/326784-formula-rotating-work-schedule.html)

[email protected]

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


[email protected]

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


Tom Ogilvy

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





All times are GMT +1. The time now is 09:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com