Fix Incorrect Duration, Finish Date, and Work Hours in Microsoft Project
Question details
The user needs to fix an issue where Microsoft Project calculates unexpected task durations, finish dates, and resource work hours.

- 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.
Ensure you have full access rights to edit the project's calendar settings and note the exact dates where the scheduling discrepancies occur.
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.
Navigate to the View tab in the top ribbon and click on Resource Sheet.
Double-click the specific resource experiencing scheduling issues to open the Resource Information dialog box.
Go to the Change Working Time tab to review the resource's assigned base calendar and exceptions.
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.

Verify Task and Project Calendars and Holiday Exceptions
Ensure that custom task calendars and overall project calendars do not conflict with your resource schedules.
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. Download and Install WPS Office: Visit the official WPS website, download the free suite, and install it on your device.
- 2. Open WPS Spreadsheet: Launch WPS Office and open a new Spreadsheet to begin managing your project data.
- 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.

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.




