If you do a quick google on keywords <Primavera calendars change>, you’ll end up with quite a few results that show you how to use Primavera’s Fill-Down feature to change the activity calendar of all the activities in a project.

But I think the fill-down piece is only the first step in changing activity calendars.

What about durations?

Changing an activity’s calendar in Primavera can actually alter the activity’s duration. It’s true. Sometimes you’ll even end up with partial or decimal durations where there were none before.

Primavera Calendars change Activity Durations

Primavera calendars and durations

 

I wanted to demonstrate how to get around this problem with a Primavera calendar change and changing durations.

In the video tutorial below, I’ll show you an alternative to using fill-down – so you can change your activity calendars AND keep your durations unchanged.


Why does Primavera change an activities duration when it changes its calendar?

That’s what we’re going to investigate in this tutorial.

Hi, I am Michael from (Plan Academy), thanks for checking us out. How I look at this activity – D&G Engineering – 160 days. If I change its calendar from 8 hours by 5day work week, to something that has different hours per day and perhaps different hours of the week like 12×6, watch what happens to the duration. It goes down significantly; it goes down from 160 days to 107 days.

Why is that happening? —I’ve been poking in the Plan Academy Support Community and I see a lot of people are struggling with this.
How can we keep those durations set the same so that when I change the calendar it doesn’t change those durations?

I want to explain first what’s going on, and the first thing we need to understand is how durations get stored in the Primavera database. Primavera P6 actually doesn’t store durations in days in the Primavera database – it stores that information in the hourly format. So why don’t we look at this situation again in an hourly view. We’re going to Edit->User Preferences and I’ll change my duration’s format to hours.

So what we can see here is that the actual hours for this activity is 1280 hours and I want to stress here that when I change calendars, this value doesn’t actually change. Primavera doesn’t edit activity durations for you when you change your calendar. So what is happening, well I’m going to show you in this picture.

Let’s say I have a five day activity which translates to 40 hours in terms of an 8 hour by 5 day work week. What happens when I change the calendar? If I change it to something with more hours per day and more days per week, this happens. Primavera takes the exact during in hours and it is now trying to fill those daily buckets to the top.

So what we end up with is more hours in a day and we’re spreading that 40 hours less thin, a little bit more thickly in the beginning of the week and it ends up calculating a duration of 3.3days. Because now with the first three days full we’ve only got ? of a day left. Here’s how Primavera calculates that, it takes our static 40 hour duration and divides it by twelve hours per day to calculate a 3.3 day original duration.

When I’m displaying my duration in days Primavera is constantly recalculating that field based on the calendar that I’ve chosen. What I want you to understand is how Primavera knows the definition of a day. So if I have two activities and I type in 1D, what does that translate that into?

Well, for this calendar it translates it into 8 hours and for this calendar it translates it into 12 hours. How does it know how to do that, is it just because I named this calendar that way? Let’s go to calendars to find out. What I want to show you here is if I modify each of these calendars, there’s a special button down here at the bottom called time periods. If I click on time periods, see this first bucket here, it says hours per day (eight), that is how Primavera knows exactly how many hours are in this day for this particular calendar. So it’s actually up to you to set this field. When you’re creating calendars you should be setting this field to the appropriate hours per day. Now have a look at the 12 hour x 6 day, no surprise its set to twelve.

Now let’s say I wanted to change the entire calendar for this project to a 12 hour x 6 day work week and I wanted the durations to stay the same for them to not change. Fortunately we can use something called a global change. So you can go up here to tools and you can go down and find this thing called global change. Okay now I’ve built this global change called 8 hour-cal to 12 hour-cal. Let’s have a look at it, and it looks like this.

It looks for activities where the calendar is equal to my old 8 hour x 5 day work week and then it’s going to perform some operations on those activities. First it’s going to update the calendar to the 12 hour x 6 day work week, so it’s going to do that for us automatically and it’s also going to update the original durations. It’s going to multiply each duration times one and a half, x1.5 because 12 hour days are 1.5 times longer than 8 hour days. Now if I run this global change, it’s going to throw some errors and that’s because updating those durations will not work for some millstones, level of effort and WBS summary activities. So if I run it in its current form it’s going to fall down.

We’ll go ahead and apply a filter and we’ll apply it to filter out those types of activities that can update which includes milestones and WBS summary as well as level of efforts; and the normal filter, filters those guys out. What I’ll have to do is after I run this is I will still have to kind of do a two-step and update the calendars of those activities but not the durations. So go back into tools, global change, go ahead and apply to changes and here are the changes it’s going to make, I’m going to go ahead and commit. By the way big note here, when you work with global changes you need to make a backup copy of your project first. BTW: in case your WBS bars show a different calendar, here’s what you can do to fix that.

Warning: Do not do this on your only copy of the project. Don’t say I didn’t warn you. So let’s go ahead and commit the changes, we’ll have a look and as you can see, I now have a new calendar applied and I have the updated durations and they were kept exactly the way I wanted them. I’m Michael Lepage; I hope you learned something from this tutorial and don’t forget to check out our online learning portal for Primavera users. Thanks!


Have your say

How did this tutorial help? What other issues arise when working with Primavera calendars and durations? Leave us a comment and join the conversation.

New Call-to-action