Show Duration in Calendar Days 1

[YANKRAY]

Using MSProjects 2000.

The Duration field shows the number of work days based on the Projects calendar. For example a 3 day duration starting on a friday would show completing on tuesday if the weekends were none work days.

How do I show the calendar days of 5 for the span of Friday through Tuesday in a field? If the field does not currently exist, what is the formula?

Thanks,
Ray

 

[PDQBach]

Paste this into the customize formula for one of the duration1-duration10 fields:

IIf([Milestone],0,datediff("d",[Start],dateadd("d",1,[Finish]))*480)

Depending on your screen settings, beware of linewrap.

 

[YANKRAY]

Thank-you PDQ this is exactly what I needed...except...

I need time of date to be considered in the calculation.

For example, I will be showing the date 5/12/06 in a summary start field, but the day should calculate from 5/12/06 at 17:00 hrs.

I have in my summary a start date of 5/12/06 17:00 hrs and a finish date of 12/3/06 17:00 hrs.

The formula is calculating 206 days. I need the calculation to be 205 days for the summary.

Ray

 

[PDQBach]

IIf([Milestone],0,datediff("d",[Start],[Finish])*480)

 

[YANKRAY]

Perfect! Thanks for the help.

Ray