Use a number column to sum the manpower over a specific range

[VSAT Ryan]

I am looking to see if one can sum the number of hours of a task after a
certain date.

For example, my development task runs from November to February (assume non
level loading). I am looking for a way (preferably using formulas in a
number column) to sum hours (work, or baseline work would be fine) from
1/1/06 to 2/28/06, and display them in the NumberX column.

Thanks in advance!

 

[DavidC]

Hi Ryan,

Why not simply create a summary task to cover those tasks you want to total
their durations? The summary task does just that simply and easily.

Hope this helps

DavidC

 

[David Capeci]

You may want to use a custom field. You can access this feature from the
drop down menu as follows Tools->Customize ->Fields

Then you can select a field type of "number" on the custom fields tab,
rename it and then use the "formula" button to create your custom field.

 

[John]

I am looking to see if one can sum the number of hours of a task after a
certain date.

For example, my development task runs from November to February (assume non
level loading). I am looking for a way (preferably using formulas in a
number column) to sum hours (work, or baseline work would be fine) from
1/1/06 to 2/28/06, and display them in the NumberX column.

Thanks in advance!

VSAT,
You basically want to sum up timescaled data and unfortunately that
can't be done (at least not easily) with a formula in a custom field.
But, that doesn't mean you can't get what you want. I can think of three
approaches.

First, re-structure you file as David C. suggested so the tasks from
1/1/06 through 2/28/06 are isolated. Then they will sum up automatically.

Second, use the Task Usage view and isolate the timescale to the period
of interest. Copy and paste data into Excel and sum it up.

Third, use VBA to gather the data you want and dump it into a spare
field.

John
Project MVP