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

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
Wed Feb 08 19:05:27 CST 2006

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

"VSAT Ryan" wrote:

> 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!

DavidCapeci
Wed Feb 08 19:11:27 CST 2006

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.



"VSAT Ryan" wrote:

> 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!

John
Wed Feb 08 19:57:31 CST 2006

In article <0F85C361-6FDB-451C-88EE-9BC95E1E548D@microsoft.com>,
VSAT Ryan <VSATRyan@discussions.microsoft.com> wrote:

> 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