Skip to content

Calendars in Microsoft Project

Lo GaryMember for 16 years 8 months
Created
4
5
0
Dear All,

I want to set different calendars for different activities
1) Calendar 1 for normal construction activities (work week Monday to Saturday 8:00a.m. to 6:00p.m.);

2) Calendar 2 for consultant working day (Monday to Friday 9:00a.m. to 6:00p.m.);

3) Calendar 3 for contagious activities ( 24 hours e.g. concrete curing, time allowed for striking of formwork etc.)

It is then found that the start and finish date/time of the activities would be mess up. How to resolve this problem?

In addition, could I force an activity to start on the next day rather than start immediately on the remaining time of the previous day. e.g. if there is only 2 hours left on day 1 which is not adequate to pour 100m3 of concrete, could the activity be force to start on day 2.


Thank!


Gary Lo

4 replies

Oldest first
  1. 0
    Mike Testro ·
    Hi Gary

    The default Time slot in MSP is Hours but it can be changed to Days:

    On the Tools menu, click Options, and then click the Schedule tab.
    In the Work is entered in list, click the time unit that you want.
    To use the same setting automatically in all future projects, click Set as Default.

    Best regards

    Mike Testro
  2. 0
    Alexandre Faulx-Briole ·
    Gary,
    MS Project only has one default start time that it is using when the planner does not enter the task start time with the task start date, or when the task start date is being calculated my MSP.
    You can change this Default Start Time in Tools, Options, Calendars, or Tools, Change Working Time, Options.
    As you will certainly have more tasks starting at 08:00 than 09:00, you will like to have 08:00 as the Default Start Time; this will allow your Consultant Tasks to start at 09:00 as 09:00 is later than the default start time; working on the contrary would be problematic.
    Should you have tasks starting automatically by the end of the day, that you would like to push automatically the next day 1st hour, you could either write (or record) a vba macro that says: "if task start time is later than 04:00 PM (for instance) then start date = start date + 1 and start time = default start time (or you can change the default start time according to task calendar)), or insert a 1 minute long task with a calendar that only has one working hour between 08:00 and 09:01 AM.
    Hope this helps
    Alexandre
  3. 0
    Lo Gary ·
    Dear Alexandre,

    Sorry that I am not familiar with VBA. Do you think you could help on this?

    Thank!


    Gary
  4. 0
    Alexandre Faulx-Briole ·
    Gary,
    unfortunately not; U can not do more than recording the macro and trying to understand it
    Alexandre

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?