Task Durations to calendar durations

[Pam S.]

Greetings,

I am having a problem converting task durations to calendar durations in MS Project Standard 2003.

The project calendar is set for a 5-day work week.
Hours per day: 8.00
Hours per week: 40.00
Days per month: 20

Task durations are entered in days in the "Duration" field.

I need to show actual calendar days, so I customized "Duration1" with the following formula: CDate([Finish]-[Start])

The calendar durations end up with a .38 afterwards, i.e., 24.38, 25.38, 18.38, 4.38.

Is there a quick fix to get the calendar durations to display as whole days? I tried the "Rnd(number)" formula but that didn't work.

Many Thanks!

Pam S.

 

[John Beamish]

Duration1 is not a good choice since it affected by the display format
(Tools | Options | Schedule tab -> duration is entered in ...)

I would use one of the number fields. This formula worked for me:
datediff("d",Start,Finish)

If you want to show a piece of text saying something like "cal days" then
use a text field and try this:
datediff("d",Start,Finish) & " cal days"


JLB, PMP

Greetings,

I am having a problem converting task durations to calendar durations in MS Project Standard 2003.

The project calendar is set for a 5-day work week.
Hours per day: 8.00
Hours per week: 40.00
Days per month: 20

Task durations are entered in days in the "Duration" field.

I need to show actual calendar days, so I customized "Duration1" with the

following formula: CDate([Finish]-[Start])

The calendar durations end up with a .38 afterwards, i.e., 24.38, 25.38, 18.38, 4.38.

Is there a quick fix to get the calendar durations to display as whole

days? I tried the "Rnd(number)" formula but that didn't work.

 

[Pam S.]

Thanks John. That worked perfectly.