Others

Why Microsoft Project Shows the Wrong Duration in Days

Muhammad TalhaMuhammad Talha Nov 18, 2026 869 views

Question details

Understand why a duration in Microsoft Project differs from the number of calendar days between its start and finish dates.

Why Microsoft Project Shows the Wrong Duration in Days
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.
Before you start

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.

Solution 1Recommended

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.

1
Find the project calendar

Open Project > Project Information and note the calendar selected for the project.

2
Review working days

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.

3
Check the day definition

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.

4
Review the result

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.

Check the project calendar and working hours
Working hours and day units are different settings: Changing Hours per day changes how Project expresses duration in days; it does not by itself make additional days or hours working time on the calendar.
Free Microsoft Office alternative

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.

Track task start dates, finish dates, and durations in a spreadsheetOpen and edit Microsoft Excel XLSX, Word DOCX, and PowerPoint PPTX filesWork with a familiar interface for a smoother transition from Microsoft OfficeUse a free, lightweight suite for everyday office work
microsoft office alternative - wps office

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.