Customizing fields - how to get durations to add up?

[reb-clo]

I have added a column in my gantt chart view on the left. I used a duration
field, so I can record approved hours. I have manually added these in for the
sub-tasks, but I wondered why they didn't add up automatically for the task
total?

Should I use a different field type for this? It seems I can only apply a
formula to the whole field, rather than just the few places where it needs to
add up the hours.

Any help appreciated.

 

[John]

I have added a column in my gantt chart view on the left. I used a duration
field, so I can record approved hours. I have manually added these in for the
sub-tasks, but I wondered why they didn't add up automatically for the task
total?

Should I use a different field type for this? It seems I can only apply a
formula to the whole field, rather than just the few places where it needs to
add up the hours.

Any help appreciated.

reb-clo,
First of all formulas in customized fields apply to all tasks in the
file. The only way to get a formula to apply to selected tasks is to use
that formula in VBA.

Second, to roll up custom field data to summary lines you need to check
one of the available options for calculation for task and group summary
rows on the Customize Fields window.

Finally, using a spare duration field for entry of hours should work
fine since Project automatically formats the spare duration fields to
accept time based data.

Hope this helps.
John
Project MVP

 

[reb-clo]

This has worked. Thank you!

reb-clo,
First of all formulas in customized fields apply to all tasks in the
file. The only way to get a formula to apply to selected tasks is to use
that formula in VBA.

Second, to roll up custom field data to summary lines you need to check
one of the available options for calculation for task and group summary
rows on the Customize Fields window.

Finally, using a spare duration field for entry of hours should work
fine since Project automatically formats the spare duration fields to
accept time based data.

Hope this helps.
John
Project MVP

 

[John]

This has worked. Thank you!

reb-clo,
You're welcome and thanks for the feedback.
John