Here is a question I received from one of my readers:
“I’m managing a project for resources in multiple locations using MS Project 2007: US and 3 countries in Europe. I have multiple resource calendars to reflect the different countries. One (1) of my German resources started a task on Nov 28 which is a holiday for the US. When I attempt to change it to Nov 28th MS Project states that Nov. 28th is a non-working day; this is correct for US resources. However since Nov 28th is a working day for the German resource why is MS Project giving me this error. I understand that the standard calendar is used for the Project tasks, but how can I use the resource calendar assigned to the task versus the standard calendar?”
I will answer this question using Project 2013, but the steps will be the same for Project 2007 as well.
First, I’m going to create a brand new Project:
Now suppose that in my project I have a guy from USA, and a guy from Germany. And suppose that in USA we have two holidays: one at Thursday, Jan 8th, and second at Monday, Jan 12th. I will create Calendar with name “USA Calendar”:
Forget about reoccurrence for a moment, it doesn’t matter in this Scenario.
Now suppose that in Germany we have two holidays: one at Tuesday, Jan 13th, and second at Friday, Jan 16th. I will create another Calendar with name “Germany Calendar”, at the same way I did with USA Calendar. I will get:
And now, I am going to create two Resources, John from USA, and Hans from Germany:
As you can see, John has USA Calendar as Base Calendar, and Hans has Germany Calendar as Base Calendar.
Finally I will assign both of them to my Task:
As you can see, Duration is now 12 days. Let’s see at the Task Usage View:
As you can see, John will not work at USA Holiday, and Hans at German’s Holidays. Both of them will work 80 hours per Task (because initial Duration was 10 days, and that means 10 days * 8 hours per day = 80 hours).
But they will work according to they own Calendar.
Hope this helps.