Re: Sum of duration

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello John.

Thanks for the explanation :-)

In that case, I would like to sum the time working (only one resource will
execute each task).

After knowing how to sum the time working, I'll try to sum only the time
spent by each resource.

An example will be better:
1. Switch on servers - Peter - 10 minutes - 10 minutes
2. Execute software - Peter - 20 minutes - 30 minutes
3. Switch on firewall and router - George - 15 minutes - 15 minutes
4. Enter new routing - George - 10 minutes - 25 minutes
5. Download DB - Peter - 30 minutes - 60 minutes

Columns:
1º) Task number
2º) Task
3º) Resource
4º) Working time
5º) Sum of working time for that resource

Thanks in advance.

"John" <mjensen@xxxxxxxxxxxx> escribió en el mensaje
news:mjensen-6B0AAC.07543616072007@xxxxxxxxxxxxxxxxxxxxxxx
In article <OAWeaM6xHHA.4736@xxxxxxxxxxxxxxxxxxxx>,
"Fambrius" <fambri.nospam.us@xxxxxxxxxxx> wrote:

Hello.

I want to do the following: I want to create a column which shows me how
much time has a resource devoted to the tastks.

Each row make a sum of the duration of the precedent tasks but not
including
the duration of the remaining tastks (the remaining rows).

I don't know how can I create a formula which sums the precedent values
of
the duration fields.

Anyone can help me?

Thanks in advance.

Fambrius,
Duration and how much time a resource spends on a task are two
completely different things. Duration is simply the time during which a
task is performed. It is the difference in working time between the
start and finish. Work on the other hand is the actual effort one or
more resources spends completing the task. If a single resource works
full time on a task, then and only then will the work equal the
duration. However this is rarely the case since tasks are often worked
by more than one resource or even if worked by a single resource, that
resource may not work on it full time.

Now, given that distinction, what exactly are you trying to do?

John
Project MVP


.

Relevant Pages

  • Re: Sum of duration
    ... I would like to sum the time working (only one resource ... 5º) Sum of working time for that resource ... Each row make a sum of the duration of the precedent tasks but not ...
    (microsoft.public.project)
  • Re: Sum of duration
    ... I would like to sum the time working (only one resource ... After knowing how to sum the time working, I'll try to sum only the time ... Take a look at either the Resource Usage or Task Usage views. ... Each row make a sum of the duration of the precedent tasks but not ...
    (microsoft.public.project)
  • Re: Are Fixed Duration tasks flawed?
    ... If we Wally and the Beave's calendar initially show the they're working the full week when we assign them to the task and then later post in the fact that Beave is booking off on Wednesday, there is, in fact, an apparent duration change for the fixed duration task. ... Each resource must work 5 working days to do their 40 hours. ... single resource, is accurate and lucid. ... we can then create a resource called Carpender Team ...
    (microsoft.public.project)
  • Re: Sum of duration
    ... the remaining tasks amount of time isn't sum. ... spent by each resource. ... 5º) Sum of working time for that resource ... the duration of the remaining tastks. ...
    (microsoft.public.project)
  • Re: Sum of duration
    ... I would like to sum the time working (only one ... spent by each resource. ... 5º) Sum of working time for that resource ... Each row make a sum of the duration of the precedent tasks ...
    (microsoft.public.project)