Why Microsoft Project for the Web Calculates Percentage Complete Incorrectly
Question details
The user needs to understand why Project for the Web calculates percentage complete unexpectedly when task effort, duration, dates, and part-time resource assignments are entered in different orders or when effort is high relative to task duration.

- Product
- Microsoft Project for the Web
- Device & OS
- not provided
- Scenario
- The user is scheduling tasks, estimating effort within fixed start and finish dates, assigning part-time resources, and updating progress in Project for the Web.
- Observed behavior
- Percentage complete values appear incorrect or unexpected depending on the order in which effort, duration, dates, and resource assignments are entered, and when effort is high compared with task duration.
Before changing the task plan, note the task start and finish dates, estimated effort in hours, assigned resource capacity, and current status date. Confirm whether you are viewing percent work complete or percent duration complete, because they are calculated differently.
Check whether Project for the Web is showing percent work complete or percent duration complete
Use this if progress values look wrong even though the task duration and effort data are correct.
Project for the Web commonly tracks completion as effort completed divided by total effort. Percent duration complete uses elapsed duration and can differ when resources are part-time or when effort is high relative to duration.
Open your project in Microsoft Project for the Web and go to the task grid view where the task list is displayed.
Select the task and compare the Percent Complete, Effort, Duration, Start, Finish, and Resource Assignment fields shown in the grid.
Check whether the displayed percentage is Percent Complete (duration-based) or Percent Work Complete (effort-based). Percent Work Complete is normally completed effort divided by total effort.
If you report progress as of a specific date, set the status date before updating progress so elapsed duration and completed effort are calculated from the intended as-of date.
Re-enter task effort, duration, and resource assignments in a consistent order
Use this when entering start and finish dates first, then adding effort or part-time resources, causes percentage complete to change unexpectedly.
Track Project Tasks in WPS Office as a Free Microsoft Office Alternative
When Project for the Web percentage complete issues require Microsoft-specific troubleshooting, WPS Office offers a free, lightweight way to manage task-tracking spreadsheets, project documents, and status reports. It opens and saves Microsoft Office formats, uses a familiar ribbon interface, and makes moving from Microsoft Office straightforward.
- 1. Download WPS Office free: Go to the official WPS Office website and download the free version for your Windows or Mac device, then complete the installation.
- 2. Create or open a task-tracking workbook: Open WPS Spreadsheet and create or import a workbook with task name, effort, duration, and percent complete columns.
- 3. Calculate and save your progress: Use a formula such as completed effort divided by total effort to calculate percent complete, then save the file as an Excel XLSX workbook.

Frequently Asked Questions
Why does Project for the Web show 50% complete when I completed 5 out of 10 effort days?
If the task result is based on percent work complete, 5 completed effort days divided by 10 total effort days equals 50%. If you see a different value, check whether the column is Percent Duration Complete or whether resource part-time capacity and status date are changing the calculation.
Should I use percent complete or percent work complete for part-time resources?
Use percent work complete for part-time resources. It is calculated from completed effort divided by total effort, so it reflects actual work; duration-based percent complete can be skewed when resources do not work full time.
Why does entering start and finish dates first change percentage complete?
When fixed dates define duration, adding a high effort estimate afterward can create a mismatch between work and available time. Enter effort in hours and review working hours and resource capacity to keep the calculation consistent.
Does setting a status date affect percentage complete in Project for the Web?
Yes. The status date controls the as-of point for progress. Set the status date before updating progress so elapsed duration and completed effort are calculated from the correct date rather than the current date.
Can WPS Office open Project for the Web files?
No. WPS Office is not a Microsoft Project replacement. Use WPS Spreadsheet to open or create Excel XLSX task-tracking workbooks, and use Writer or Presentation for project documentation and reports.




