Others

Fix Incorrect Duration, Finish Date, and Work Hours in Microsoft Project

Kushani NimanthikaKushani Nimanthika Nov 4, 2026 870 views

Question details

The user needs to fix an issue where Microsoft Project calculates unexpected task durations, finish dates, and resource work hours.

Fix Incorrect Duration, Finish Date, and Work Hours in Microsoft Project
Product
Microsoft Project
Device & OS
not provided
Scenario
Using custom task calendars, resource calendars, holidays, and multiple work schedules for project management.
Observed behavior
Microsoft Project calculates an unexpected task duration, finish date, and resource work hours due to potential calendar misconfigurations.
Before you start

Ensure you have full access rights to edit the project's calendar settings and note the exact dates where the scheduling discrepancies occur.

Solution 1Recommended

Check and Update Resource Calendar Settings

Verify that specific dates are not incorrectly marked as nonworking in the resource's base calendar.

Often, a resource's individual calendar will override standard project working days. If a resource has an accidental nonworking day marked (such as an incorrect holiday), their assigned tasks will stretch longer than expected.

1
Open the Resource Sheet

Navigate to the View tab in the top ribbon and click on Resource Sheet.

2
Access Resource Information

Double-click the specific resource experiencing scheduling issues to open the Resource Information dialog box.

3
Review Working Time

Go to the Change Working Time tab to review the resource's assigned base calendar and exceptions.

4
Remove Incorrect Nonworking Days

Check for any dates incorrectly set as nonworking days and delete those exceptions. Click OK to save the changes and see if the task duration updates automatically.

Check and Update Resource Calendar Settings
Calendar Priority: Remember that a task calendar does not need to replace the resource calendar; they can work in tandem unless specifically configured to ignore one another.
Free Microsoft Office alternative

Manage Project Schedules Easily with WPS Office

While Microsoft Project offers advanced scheduling, it can sometimes be complex and prone to calendar conflicts. If you are looking for a straightforward, highly compatible alternative for tracking project timelines, Gantt charts, and resource hours, WPS Office provides excellent spreadsheet capabilities that are fully compatible with Microsoft Excel formats. Enjoy a lightweight, free suite with a familiar interface for seamless project management.

  1. 1. Download and Install WPS Office: Visit the official WPS website, download the free suite, and install it on your device.
  2. 2. Open WPS Spreadsheet: Launch WPS Office and open a new Spreadsheet to begin managing your project data.
  3. 3. Use Project Management Templates: Search for free Gantt chart or project tracking templates in the WPS Template library to instantly set up your schedule without complex calendar configurations.
Create and track project Gantt charts easily in WPS Spreadsheet.Fully compatible with Microsoft Office formats (.xlsx, .docx, .pptx).Free, lightweight, and fast installation compared to traditional Office suites.Familiar, user-friendly interface requiring no steep learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my task duration not match the resource work hours in Microsoft Project?

This typically occurs when the task type is set to 'Fixed Duration' or 'Fixed Work', or when there is a mismatch between the overarching project calendar and the specific resource's calendar. Conflicting nonworking days can drastically alter the calculation.

How do I ignore resource calendars for a specific task?

Double-click the task to open Task Information, navigate to the Advanced tab, select a specific Task Calendar from the drop-down menu, and check the box that says 'Scheduling ignores resource calendars'.

Can holiday exceptions affect the finish date of my project tasks?

Yes. If a holiday exception is added to the project or resource calendar, Microsoft Project treats those days as nonworking. This will naturally extend the task duration and push back the overall finish date of the task.