Forum Discussion
MS Project Professional Master File Duration less than duration of highest Subproject
Hi,
Hoping someone can help with this one.
Created a Master Project file to track multiple projects and when I insert the first Subproject ("Finance Department Audit Process"), the Master Project Duration is less than the Subproject summary.
Any suggestions on how I can reconcile this would be greatly appreciated.
Cheers!
| Task Mode | Task Name | % Complete | Duration | Start | Finish |
| Auto Scheduled | Master Project | 55% | 349 days? | 2022-01-11 | 2023-05-12 |
| Auto Scheduled | Finance Department Audit Process | 55% | 354 days? | 2022-01-11 | 2023-05-12 |
| Auto Scheduled | 22-Audit ABC | 47% | 180 days? | 2022-06-22 | 2023-02-23 |
| Task Mode | Task Name | % Complete | Duration | Start | Finish |
| Auto Scheduled | Production Audit Process | 55% | 259 days? | 2022-03-13 | 2023-03-02 |
| Auto Scheduled | 22-Audit ABC-D | 55% | 259 days? | 2022-03-13 | 2023-03-02 |
- KenPb,
Yeah that gave me just enough info. Indeed if subproject ABC has exceptions which allow Sunday to be working time then you will see an apparent discrepancy in the Duration field. The master file has the Standard calendar so it is measuring duration time per that calendar which means it will not count Sundays.
It's not clear what you are trying to achieve. You can create a custom Text field with the following formula and it will display the same duration as subproject ABC but only for the case where subproject ABC is the dominant subproject (i.e. starts earlier and finishes later than any other subproject). Why? Because the formula simply measures calendar time instead of working time.
Text1=DateDiff("d",[Start],[Finish]) & " days".
If another subproject has an earlier start or a later finish, then the formula will give an invalid duration. So again, I'm not sure what you are trying to achieve.
Is there a way to create a custom duration at master level that will respond to the intent regardless of whether the subproject with the exceptions is dominant or not? Yes, but it would require VBA.
John
KenPb,
Thanks for the picture but it doesn't give quite enough information. For example, what is the task ID for each of the tasks shown in your "screen shot"?
Other relevant information:
1. What is the Project calendar for the master?
2. What is the Project calendar for each subproject?
3. If calendars are different, what are the differences (e.g. working hours, working days, hours per day, etc.)?
4. In the master do you have the calculation option set to "on"?
5. Also in your Project options do you have "inserted projects to be calculated like summary tasks"?
JohnJohn-project Hi and thanks for the reply. The calendars for the master and sub projects are all standard M-F 40hr work week however in one of the sub projects there are a number of exceptions where a task start and completion date was on a non working day. I believe this might be the issue. Any recommendations to resolve?
Thanks, Ken
- KenPb,
Thanks for answering a few questions but you still didn't answer the main question, namely, what is the task ID for each of the lines shown in your "screen shot"?
I'd also like to see the Start and Finish fields for all the tasks shown. As far as the subproject with calendar exceptions I can't offer any recommendations until I see more.
John
