#1
|
|||
|
|||
2-2-3 schedule
Is there a way to autogenerate days of a year for overtime on a 2-2-3 schedule? This type of schedule is one week you work Sunday, Wednesday, Thursday. The next week is Monday, Tuesday, Friday, and Saturday. They just alternate. I need to make up a list for people to be able to sign up but not have to keep typing the dates and month. |
#2
|
||||
|
||||
Yes, but it is going to be a lot easier to do in Excel.
Post a sample document so we can see what it is you want. Then we will be able to suggest the best way of achieving your aims.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
|||
|
|||
Basically all I need is going to be
Dec 6 2021 Dec 7 2021 Dec 10 2021 Dec 11 2021 With spaces in between the dates for two people to be able sign up. But to generate the dates automatically for just the days I would need and not the other shifts. Is there a way to post a picture of our calendar of how we work on here? |
#4
|
||||
|
||||
You can attach a file to your post by clicking on the Go Advanced button and using the paperclip button.
I would recommend you look at Excel for this. There are plenty of videos on YouTube that give you ideas on what you can do. Something like this looks very comprehensive and includes colour coding to show the alternating shifts #163-How to make Duty Roster in Excel Step by Step | Automatic Shift Schedule - YouTube
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Importing schedule into another schedule and keeping the links | abby1428 | Project | 0 | 03-16-2018 04:21 PM |
Same Schedule, but different leveling | stahleen17 | Project | 1 | 10-01-2017 04:49 PM |
update schedule | a.mousavi_1368@yahoo.com | Project | 1 | 03-16-2017 10:20 PM |
Tasks behind schedule | lordtopcat | Project | 2 | 07-12-2016 02:49 PM |
Schedule Converging | andrew22xc | Excel Programming | 8 | 06-01-2015 10:44 PM |