Forum Discussion
MS Project Standard 2021 calculating duration incorrectly
- Dec 06, 2023
Hi anjseattle
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
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.
- anjseattleDec 05, 2023Copper Contributor
Dale_HowardMVPhere 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.
- Ignacio_MartinDec 06, 2023Iron Contributor
Hi anjseattle
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
- anjseattleDec 06, 2023Copper ContributorThank you! The hours per week worked. I am familiar with the various ways of constraining tasks, but I would have never looked for this.