how to calculate the sum of durations of subtasks for a summary ta

[Elena Osipova]

Hi! Could you please help me with this? I know how to create custom fields,
but don't know how to write and use VBasic scripts. As I understand, my task
needs scripting.

I need to add a column, where for summary tasks the sum of durations of
subtasks will be indicated, while for subtasks - their durations. The
difference from the ordinary duration field is that here I need a total sum
of subtasks's durations, not the longest duration for their fullfillment.

I will appreciate any help.
Thanks. Elena.

 

[Rod Gill]

Don't use VBA: use formulas. Formula for subtask is simply=[Duration]. Use a
separate formula for summary tasks that sums [Duration].

 

[Elena Osipova]

Thanks Rod.

Is it possible to use separate formulas for the same field depending on
whether it is a subtask or a summary task? How can I do this?

"Rod Gill" пишет:

Don't use VBA: use formulas. Formula for subtask is simply=[Duration]. Use a
separate formula for summary tasks that sums [Duration].

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

Hi! Could you please help me with this? I know how to create custom
fields,
but don't know how to write and use VBasic scripts. As I understand, my
task
needs scripting.

I need to add a column, where for summary tasks the sum of durations of
subtasks will be indicated, while for subtasks - their durations. The
difference from the ordinary duration field is that here I need a total
sum
of subtasks's durations, not the longest duration for their fullfillment.

I will appreciate any help.
Thanks. Elena.

 

[Rod Gill]

Select Tools, Customize, Fields and you will see separate options for
summary tasks and other tasks. Click the relevant formula button to create
the formula.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

Thanks Rod.

Is it possible to use separate formulas for the same field depending on
whether it is a subtask or a summary task? How can I do this?

"Rod Gill" ?????:

Don't use VBA: use formulas. Formula for subtask is simply=[Duration].
Use a
separate formula for summary tasks that sums [Duration].

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

Hi! Could you please help me with this? I know how to create custom
fields,
but don't know how to write and use VBasic scripts. As I understand, my
task
needs scripting.

I need to add a column, where for summary tasks the sum of durations of
subtasks will be indicated, while for subtasks - their durations. The
difference from the ordinary duration field is that here I need a total
sum
of subtasks's durations, not the longest duration for their
fullfillment.

I will appreciate any help.
Thanks. Elena.