Customer Duration Calculation

[TKS_Mark]

We defined field duration10 using a formula. The formula is
[Start]-[Start10], where start10 is another custom field. Unfortunately, the
duration comes out at fractions of a day instead of the true duration. Is
there some way to convert this into true duration? I think its spitting out
a dateserial or something currently.

 

[JulieS]

Hi TKS_Mark,

Try the following formula in a spare number field (Number1 for example)

ProjDateDiff([Start],[Start10])/[Minutes Per Day]

This will calculate the number of working days (defined in the standard
calendar) between the two dates.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project