Others

How to Fix Microsoft Project Work, Units, and Duration Mismatches

Elise WilliamsElise Williams Nov 2, 2026 869 views

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.

Why Microsoft Project Work, Units, and Duration Do Not Match
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.
Before you start

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.

Solution 1Recommended

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.

1
Switch to a Usage View

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.

2
Insert the Assignment Units Column

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.

3
Insert the Peak Column

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.

4
Compare the Values

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.

Use the Peak Column in Usage Views to See Calculated Units
No Manual Adjustments Required: This is expected functionality and not a software bug. As long as the Peak column reflects the accurate calculated values, you do not need to manually change your assignments to force the numbers to match.
Free Microsoft Office alternative

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. 1. Open WPS Spreadsheet: Launch WPS Office and select "Spreadsheet" from the main dashboard to start your project tracker.
  2. 2. Access Project Templates: Click on "New" and browse the template library by searching for terms like "Project Management" or "Gantt Chart".
  3. 3. Customize and Share: Input your task details, assign resources, adjust duration formulas, and save your workbook in .xlsx format to share with stakeholders.
Easily track project duration, work, and resource units using customizable spreadsheet formulas.High compatibility with Microsoft Excel formats (.xlsx, .xls) ensures seamless sharing with your team.Completely free and lightweight, offering an intuitive interface for immediate productivity.Access a rich library of free templates including Gantt charts, timelines, and project trackers.
microsoft office alternative - wps office

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.