How to Handle Diif Calendar in MSP 2007 Schedule

P
Peter May 👤 Member for 14 years 4 months

I have created a Schedule which consists of fabrication and Construction Activities. Since this is a Shipyard Project during the construction phase the work will be done 24 hrs.

I have following settings in my project.

Project calendar is Standard.( 7 days a week and 10.5 hrs per day).Since this will be the working duration in fabrication Phase.

However in the construction period the working hrs should be 24 hrs per day, so I have assigned task calendars to all the activities.

My default working hrs per day is 10.5 hrs from 7 am to 18.30 pm.

I created a duration field with the formula : IIf([Task Calendar]="24 Hours",[Duration]*10.5/24,[Duration])

I am facing below problems.

The duration for the shipyard activities  is not showing correctly. I mean in the duration tab it is showing 1.3 days but the start to finsh date is only 3 days.

 I created a duration field with the formula : IIf([Task Calendar]="24 Hours",[Duration]*10.5/24,[Duration]). This work fine in converting my duration, however I noticed that when I input a new activity the duration is fixed at 1day and  start and finish date does not  calculate.

Can I not manage to show the duration and the start and finish dates correctly in MSP while working with diff calendar options...........

2) What should be the approach for preparing schedule involving diff working hrs in diff   phases...

Please guide me...

  

I have created a Schedule which consists of fabrication and Construction Activities. Since this is a Shipyard Project during the construction phase the work will be done 24 hrs.<?xml:namespace prefix = o />

 

I have following settings in my project.

 

Project calendar is Standard.( 7 days a week and 10.5 hrs per day).Since this will be the working duration in fabrication Phase.

 

However in the construction period the working hrs should be 24 hrs per day, so I have assigned task calendars to all the activities.

 

My default working hrs per day is 10.5 hrs from 7 am to 18.30 pm.

 

I created a duration field with the formula : IIf([Task Calendar]="24 Hours",[Duration]*10.5/24,[Duration])

 

I am facing below problems.

 

The duration for the shipyard activities  is not showing correctly. I mean in the duration tab it is showing 1.3 days but the start to finsh date is only 3 days.

 

 I created a duration field with the formula : IIf([Task Calendar]="24 Hours",[Duration]*10.5/24,[Duration]). This work fine in converting my duration, however I noticed that when I input a new activity the duration is fixed at 1day and  start and finish date does not  calculate.

 

Can I not manage to show the duration and the start and finish dates correctly in MSP while working with diff calendar options...........

 

2) What should be the approach for preparing schedule involving diff working hrs in diff   phases...

 

Please guide me...

 

P
Peter May 👤 Member for 14 years 4 months

Hi Trevor, I have don this earlier on but my PM insist he wants to see the  activities with 24 hrs in days, thats was the reason

Is there any work around to this please?

Thanks

T
Trevor Rabey 👤 Member for 20 years 6 months

Your points one by one:

The project calendar is "standard". actually, it isn't. or rather, the standard calendar has been changed to be 7d x 10.5h.

You should copy this calendar and give the copy an appropriate name such as "AA 7d x 10.5h". Then recover the original standard calendar (5d x 8h) from the global template (tools, organizer).

Then assign your "AA 7d x 10.5h" as the project calendar.

Yes, assign the 24 hours calendar to all tasks which can run 24 hours.

Input the durations of those tasks in hours, not days, so that there is no need to rely on the conversion factor for hours/day.

You don't need either of the formulae for what you need to do.

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts