Mismatch between custom duration formula and project settings duration column

Cory Strischek

Why do I often get a 1 in a custom duration calculation of same-day work vs. project settings calculation, which shows 0?

During some import troubleshooting, I created a "baseline duration" and "revised duration" column to compare my own formula for calculating duration to the durations provided by project settings.

My formula for calculating "Baseline Duration" is here:

=NETWORKDAY([Baseline Start Date]@row, [Baseline End Date]@row)

"Revised Duration" Project settings look at Revised Start Date and Revised End Date.

So, for the most part, these numbers will match. Here are some circumstances where they do not.

Baseline Start Date 10/27/20

Revised Start Date 10/27/20

Baseline End Date 10/27/20

Revised End Date 10/27/20

Baseline Duration 1

Revised Duration 0

Paul Newcome

Because the function you are using considers that as 1 day whereas the project settings see it as a milestone which has a zero day duration.

Paul Newcome

Because the function you are using considers that as 1 day whereas the project settings see it as a milestone which has a zero day duration.