Work Schedule

[Sampson_1]

Hello
I would like to start off with I have some random knowledge of Excel and willing to learn more however with all the different uses for Excel I'm not entirely sure what courses/ lessons to sign up for.
I'm looking to build a schedule for my work that at a push of a button will fill in the different criteria if times change or a different position becomes available.
We have 8 Different start times, 7 are 10.75 hour long shifts and one is an 8 hour long shift.
We rotate positions at the top of the hour regardless on the start time of the shift. Ex: Shift starts at 21:45 you would be in one position for 15 minuets and then rotate again at the top of the hour.
Our first and last position of each shift is always an "Office" position so at the start of each shift we can catch up on emails and at the end of the shift we can follow up on emails or wright any reports that need to be done. This position I would like to have at a minimum of 30 minuets if at all possible for both the start and end of the shift.
2 positions are standing/ walking around and the other 2 are in a sitting position, there is a "Float" position available to help with possible overlap to be used only if necessary. I would like to have these offset each other so your not sitting or standing longer then an hour. Sitting, standing, sitting, standing ... etc.
A button to put in the appropriate rotation position for each shift so nothing overlaps and can be pushed for example that if your start time changes from a 21:45 to a 22:15 your new rotation position would change, and as would others to accommodate you being in the "Office" position at the start of your shift.

[alansidman]

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

https://www.mrexcel.com/board/thread...-help.1131510/