gantt chart actual duration

[J Boomer]

I am trying to tag tasks with the actual calender duration of the task. The
standard duration tag ignores the non-working days. I tried to create a
custom duration that used the Datediff function from the start to finish
dates, but this did not seem to work. I did not get an error, but the answer
was not accurate. Thanks to anyone who can help.

 

[JulieS]

Hi J Boomer,

You can try a trick that I suggested to another user.

There is a work around using a custom duration field and a custom calendar.
Create a new calendar (Tools>Change Working Time). Copy the project
calendar, name it (I used 7Day) and make Saturdays & Sundays working days.
Then insert a custom duration field ([Duration1] for example) in the task
table. Choose Tools>Customize > Fields and select the [Duration1] field.
Click the Formula... button and use the following formula:

ProjDateDiff([Start],[Finish],"7Day")

In the Customize fields dialog box, click the Use Formula option for the
task and group summary rows.

This will calculate the number of calendar days between the start of the
task and the finish of the task using the 7Day calendar. .

Hope this helps. Let us know how you get along.

Julie

 

[J Boomer]

Worked like a champ. Thanks a bunch, Julie!

 

[JulieS]

Hi J Boomer,
You are most welcome and thanks for the feedback.
Julie