Why Microsoft Project Shows the Wrong Duration in Days
Question details
Understand why a duration in Microsoft Project differs from the number of calendar days between its start and finish dates.

- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- A project or task spans a date range, but its displayed duration in days does not match the expected count.
- Observed behavior
- The displayed duration can vary with working days, working hours, the definition of a day, and the start and finish times.
Identify the task or project date range you want to check and decide whether you expect calendar days or working days. If weekends should count, confirm the intended working hours for each day.
Check the project calendar and working hours
Use this method when weekends or other dates should count toward the project duration.
Microsoft Project calculates scheduled duration using working time, not simply the number of dates on the calendar. A seven-day calendar still needs working hours defined for each day.
Open Project > Project Information and note the calendar selected for the project.
Open Project > Change Working Time and select that calendar. Check the Work Weeks and Exceptions settings, including whether Saturday and Sunday have the intended working hours.
Go to File > Options > Schedule and review Hours per day and the default start and end times. Make sure they reflect how you intend to express duration in days.
Return to the task list and check the Duration column after applying any calendar changes. Compare the result with the working hours in the selected date range.

Inspect start and finish times and task calendars
Use this check when the dates appear correct but partial days or task-specific settings may affect the duration.
Track project dates in WPS Spreadsheets
WPS Office is a free, lightweight alternative for everyday documents and spreadsheets, with a familiar interface and compatibility that makes moving common Office files easy. Use WPS Spreadsheets to track project dates in a table; it does not fix Microsoft Project scheduling or replace its calendar calculations.

Frequently Asked Questions
Why doesn't Project count every calendar day in a duration?
Project normally calculates scheduled duration using working time defined by the applicable calendars. Check Project > Change Working Time for nonworking days and hours.
How do I make Saturday and Sunday working days?
Open Project > Change Working Time, select the relevant calendar, and edit its Work Weeks so Saturday and Sunday have the intended working hours. Check for Exceptions that override those settings.
Does changing Hours per day make the workday longer?
No. File > Options > Schedule controls how working time is expressed in day units. Change Working Time controls when work can be scheduled.
Why does the finish time affect the displayed duration?
A task that starts or finishes partway through a working day can include a partial day of working time. Choose a date format with time under File > Options > General, then inspect the Start and Finish columns.
Can a task use a different calendar from the project?
Yes. Double-click the task and check the calendar on the Advanced tab in Task Information. Assigned resource calendars can also affect when a resource-scheduled task is worked.




