How to Fix Microsoft Project Work, Units, and Duration Mismatches
Question details
Users notice an apparent calculation error where modifying task duration or work in Microsoft Project does not update the resource units as expected based on the standard scheduling formula.

- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- Updating project schedules by modifying a task's Work or Duration values and checking the resulting resource allocations.
- Observed behavior
- The Assignment Units value remains unchanged after work or duration changes, creating a mathematical mismatch, because the software preserves the originally entered allocation instead of displaying the new dynamically calculated units.
Verify your specific Task Type (Fixed Work, Fixed Units, or Fixed Duration) and whether the task is effort-driven, as these settings determine exactly how Microsoft Project recalculates your data.
Use the Peak Column in Usage Views to See Calculated Units
Add the Peak column to your Task Usage or Resource Usage view to display the accurate, recalculated maximum resource units.
This behavior was introduced in Microsoft Project 2010 to resolve a historical calculation bug. When you adjust Work or Duration, Project now preserves the original "Assignment Units" value you initially entered.
Instead of overwriting your initial entry, Project calculates the required resource units based on your new changes and stores this value in a separate field called "Peak". You just need to display this field to see the mathematically correct data.
Navigate to the View tab on the ribbon and click on either "Task Usage" or "Resource Usage". The Peak column is only available in these timephased views.
Right-click on any existing column header in the table area, select "Insert Column", type "Assignment Units", and press Enter to display the originally entered resource units.
Right-click a column header again, choose "Insert Column", type "Peak", and press Enter. This column will display the new units that Microsoft Project automatically calculated.
Review the data. The Assignment Units will show your initial input, while the Peak column will reflect the correct mathematical result of your recent Work or Duration changes.

Simplify Project Tracking with WPS Office Spreadsheet
Microsoft Project's complex resource leveling and unit calculations can sometimes be overwhelming. For straightforward project management, WPS Spreadsheet offers a lightweight, free alternative to track tasks, create Gantt charts, and monitor resources without the steep learning curve.
- 1. Open WPS Spreadsheet: Launch WPS Office and select "Spreadsheet" from the main dashboard to start your project tracker.
- 2. Access Project Templates: Click on "New" and browse the template library by searching for terms like "Project Management" or "Gantt Chart".
- 3. Customize and Share: Input your task details, assign resources, adjust duration formulas, and save your workbook in .xlsx format to share with stakeholders.

Frequently Asked Questions
Why does Microsoft Project use both Assignment Units and Peak?
Microsoft introduced the Peak field to store the maximum dynamically calculated units after a schedule modification. This allows the software to safely preserve the original Assignment Units value so you always have a record of the resource's initial allocation.
How do Task Types affect the Work, Units, and Duration calculation?
Microsoft Project relies on the formula: Work = Duration × Units. Depending on whether your task is set to Fixed Duration, Fixed Units, or Fixed Work, Project will lock one of these variables. If you change one of the flexible variables, Project automatically recalculates the third one.
Can I display the Peak column in the standard Gantt Chart view?
No, the Peak column relies on timephased assignment data. It can only be accurately displayed and interpreted within the Task Usage or Resource Usage views.




