I want to know how I can automatically calculate the total of all activity
durations in any given day, week, month, year.

I now have to count down a schedule graphically, for each month, using 20
days per month max, to calculate the the total work days for the month.

Example: say 5 activities are active in the month of April. Three of the 5
are active for the whole month and two are active for 10 days during the
month. Thus,

(3 x 20 = 60 work days) + (2 x 10 = 20 work days) = 80 work days of total
activity in those 5 activities for the month of April.

Does anyone know how to get Project to do this?

Thxs, Joe

Re: how to get total duration of all tasks in month, day, etc.? by JackD

JackD
Fri Oct 28 16:51:22 CDT 2005

Display the WORK column.

--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
.
"JoepL" <JoepL@discussions.microsoft.com> wrote in message
news:DB467A0B-488F-4298-9A91-57D6D256DC12@microsoft.com...
> I want to know how I can automatically calculate the total of all activity
> durations in any given day, week, month, year.
>
> I now have to count down a schedule graphically, for each month, using 20
> days per month max, to calculate the the total work days for the month.
>
> Example: say 5 activities are active in the month of April. Three of the 5
> are active for the whole month and two are active for 10 days during the
> month. Thus,
>
> (3 x 20 = 60 work days) + (2 x 10 = 20 work days) = 80 work days of total
> activity in those 5 activities for the month of April.
>
> Does anyone know how to get Project to do this?
>
> Thxs, Joe
>
>