ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro for a Rotating Shift Schedule (https://www.excelbanter.com/excel-programming/343748-macro-rotating-shift-schedule.html)

smck

Macro for a Rotating Shift Schedule
 
I am not sure if this is possible however, I am posting it in case someone
has a macro and does not mind sharing it.

I would like a macro to generate rotating shifts schedule based on the
following:
Person A works on Monday (8-4), Tuesday (8-5), Wednesday (1-9) and every 1st
weekend (8-4)
Person B works on Monday (8-5), Thursday (1-9), Friday (8-5) and every 2nd
weekend (8-4)
Person C works on Tuesday (1-9), Thursday (8-4) Friday (8-5) and Every 3rd
weekend (8-4)

Any help or suggestions is greatly appreciated.
Thanks.


All times are GMT +1. The time now is 07:50 AM.

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