SOLVED

MS Project Standard 2021 calculating duration incorrectly

Copper Contributor

All of my tasks are auto-scheduled. ALL of my tasks are calculating in DAYS even though the Duration  units show as weeks, months, etc. Why are duration units showing up incorrectly? In my previous desktop version THIS DID NOT HAPPEN, I was able to enter any unit and MS Project would include them all & calculate durations correctly. So frustrated - this is throwing all of my old schedules out of whack and the incorrect units is very dangerous.

 

4 Replies
anjseattle --

Well, since you did not include any screenshots, we can only guess what is going on. Since you indicated your have been planning in months, were you aware that in Microsoft Project, a "month" is the equivalent of 20 working days. This option is specified in the Project Options dialog on the Schedule page. It is the Days Per Month option.

If you really want our help, please share a screenshot or two so we can see what is going on in your project. Hope this helps.

@Dale Howardhere is a screenshot; notice that the durations showing days are correct, but the ones showing weeks are not - where "12 weeks" is shown, it is calculating to 12 days. These are fixed duration tasks, no resources, standard 40 hour workweek.

anjseattle_1-1701810397360.png

 

 

 

best response confirmed by Dale Howard (MVP)
Solution

Hi @anjseattle 

 

Error horas por semana.png

 

 

As Dale pointed out, you most likely have 8 hours in the Hours per week option of your project.

If so, I recommend that you follow the following steps to avoid losing part of your work, if the values shown in the Duration column, at the task level not summary task, are correct:

 

1. In the tasks table, clear all active filters and expand all summary tasks.
2. Select and Copy the Duration column (to clipboard)
3. Change to 40 hours, the Hours per week option for your project.
4. Paste the Duration column.
5. Put all tasks in Auto Scheduled Task Mode.

 

N.- The final result of the dates will depend on the different restrictions of the Finish no Earlier Than type, which apparently many of the tasks shown in your screenshot have. I remind you that one of the ways to eliminate them is to leave Type in As Soon As Possible.

 

I hope you find it useful.

Ignacio Martín

Thank you! The hours per week worked. I am familiar with the various ways of constraining tasks, but I would have never looked for this.
1 best response

Accepted Solutions
best response confirmed by Dale Howard (MVP)
Solution

Hi @anjseattle 

 

Error horas por semana.png

 

 

As Dale pointed out, you most likely have 8 hours in the Hours per week option of your project.

If so, I recommend that you follow the following steps to avoid losing part of your work, if the values shown in the Duration column, at the task level not summary task, are correct:

 

1. In the tasks table, clear all active filters and expand all summary tasks.
2. Select and Copy the Duration column (to clipboard)
3. Change to 40 hours, the Hours per week option for your project.
4. Paste the Duration column.
5. Put all tasks in Auto Scheduled Task Mode.

 

N.- The final result of the dates will depend on the different restrictions of the Finish no Earlier Than type, which apparently many of the tasks shown in your screenshot have. I remind you that one of the ways to eliminate them is to leave Type in As Soon As Possible.

 

I hope you find it useful.

Ignacio Martín

View solution in original post