Share via

Shift work calendar

Anonymous
2021-09-22T19:50:08+00:00

How can I add a second set of shift patterns (using monthly grid view).

We have 4 shifts in our 247 plant.

Shift A and B are day shifts, and follow a 2/2/3 schedule. no problem, that set up easily.

However, C and D are the overnight shifts, working the same days as A and B, but on a 4/4 schedule.

So it seems I would have to add a second shift pattern to reflect C and D, but can't figure out how to do it.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

7 answers

Sort by: Most helpful
  1. Anonymous
    2021-09-27T15:01:59+00:00

    Thank you, I replied to Shane with the example of what I am trying to do.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2021-09-27T15:01:28+00:00

    Yes, here is an example of our current production schedule. Shifts A and B run on a 2 on, 2 off, 3 on, 3 off schedule. C and D shifts run on a 4 on, 4 off schedule.

    However, the program has only one place for a shift pattern. Ultimately I would like 3 total shift patterns so I can keep all of the schedules on one spreadsheet

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2021-09-25T04:09:25+00:00

    Hi MichelleNorton2

    Could you show us a sample of what you currently have and what you are look for?

    Thanks,

    Shane

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2021-09-25T02:34:04+00:00

    Hi,

    Feel free to post back with some more details if the concern persists.

    Best Regards,

    Mia

    Was this answer helpful?

    0 comments No comments
  5. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more