0

The date calculation in excel and MS project is different. Excel includes starting date for duration calculation when equation is applied, but MS Project does not include it.

For example from 21-Mar to 22-Mar, excel sees it as 2 days but MS Project calculate as 1 day.

Is there any way to change the setting of MS Project to include the starting date for duration calculation?

1 Answer 1

0

from 21-Mar to 22-Mar, excel sees it as 2 days

In Excel, subtracting these two dates gives an answer of 1 which what Project would give with those exact dates. However, the key thing to remember is the time component. These two images from Project show the same task, the only difference is how the dates are displayed. The task has a duration of 2 days because it spans 16 working hours and a "day" is defined as 8 hours.

In both Excel and Project, dates are stored as numbers (double) where the integer component is the day and the decimal part is the time. For example, Mar-21 8:00 is stored as 45372.3333333333. In Excel, unless a time component is explicitly entered, the dates have no time part (e.g. the time is midnight), subtracting one date from another gives the number of calendar days between them.

In Project, date math (adding, subtracting) is almost always* done using the calendars that define which hours are working. This is at the heart of what Project does and is not easily replicated in Excel.

** Elapsed durations are the exception--elapsed durations ignore working time and are calculated as in Excel.

1
  • Rachel, I think this is an excellent explanation for one of the key differences users see between dates/times in Excel and Project. Mar 21 at 18:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.