none
How to create specialised working schedule (11 days working with 3 days off). MS Project standard 2010 RRS feed

  • Question

  • Hello,

    I have just started using MS Project Standard 2010, and want to create a working schedule wherein i have 11 days of straight work with 3 days off.I want this to be a recurring thing as this is how our crews work.

    how do i achieve this in MS Project.

    Thanks in advance for the answers. Much appreciated.

    Friday, November 15, 2013 7:25 PM

All replies

  • Hi MS Project Newbe,

    To do that, you have to create a new calendard ("project" tab in the ribon, "change working time" option).

    Please find a link below:

    http://office.microsoft.com/en-us/project-help/set-working-times-vacations-and-holidays-for-your-project-HA010351554.aspx

    Hope this helps.


    Guillaume Rouyre - MBA, MCP, MCTS

    Friday, November 15, 2013 7:28 PM
    Moderator
  • MS Project Newbe --

    This is not going to be an easy task.  In addition to the steps Guillaume has provided, you will need to set a Sunday through Saturday as working days, and then manually mark every set of three days as nonworking time periods.  There is no way to make these nonworking days recurring days.  Believe me, I tried.  So, you have quite a bit of work ahead of you.  Hope this helps.


    Dale A. Howard [MVP]

    Friday, November 15, 2013 8:02 PM
    Moderator
  • Thanks a lot Guillaume for the info. much appreciated :)
    Friday, November 15, 2013 8:04 PM
  • Indeed Dale is right (as usual)! There is no way to set recurring exceptions in a calendar, so it'll be a tedious and manual operation.

    Guillaume Rouyre - MBA, MCP, MCTS



    Friday, November 15, 2013 8:05 PM
    Moderator
  • That was the fear i had to begin with. seems i have a long way to go. thanks for the info.

    much appreciated.

    Friday, November 15, 2013 8:06 PM
  • This might be QED (Quite Easily Done) with a VBA script.  I'll bet Rod Gill would have some good ideas about how easy or difficult this might be.



    • Edited by Edward Hanna Friday, November 15, 2013 9:11 PM Remove signature
    Friday, November 15, 2013 9:11 PM
  • Thanks a lot Edward. i shall look into this. Seems VBA is the secret code for a good number of Microsoft related tough ques.
    Friday, November 15, 2013 9:28 PM
  • Unless I am missing something (highly likely) this can be done without too many trials.  You'll need to make 3 recurring non-working days.

    I started on January 1 2014.  All 7 days are working.  I then made January 12 a non-working day repeating every other week on Sunday for 100 occurrences. I made January 13 a non-working day repeating every other week on Monday for 100 occurrences.  I made January 14 a non-working day repeating every other week on Tuesday for 100 occurrences.  I believe this gives me the 11 days on - 3 days off schedule.

    I hope this helps.


    Friday, November 15, 2013 10:04 PM
    Moderator
  • Thanks a lot Julie. I will give this a try, and update how this method works for me.

    Much appreciated.

    Friday, November 15, 2013 10:14 PM
  • Great.  Keep us posted.
    Friday, November 15, 2013 10:15 PM
    Moderator