Sum of duration

[Fambrius]

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.

 

[John]

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

 

[Fambrius]

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]

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.

Fambrius,
Take a look at either the Resource Usage or Task Usage views. The Task
Usage view will probably be best for showing what you want. If you
display the Work field as a column in the tabular data on the left, it
will be the sum of working time for each assignment (i.e. resource),
whereas the timescale data on the right will show working time for each
assignment broken down by time increments.

Hope this helps.
John
Project MVP

 

[Fambrius]

Hello John.

I'll try what you've said, but I could make what I wanted using the
following formula:

ProjDateDiff([Comienzo del proyecto];[Fin]) & "'"

Regards.

 

[John]

Hello John.

I'll try what you've said, but I could make what I wanted using the
following formula:

ProjDateDiff([Comienzo del proyecto];[Fin]) & "'"

Regards.

Fambrius,
OK, whatever works best for you.

John

 

[Fambrius]

Hello again.

I have a problem.

If I create subtasks, then my formula doesn't work. It shows 0 and, once the
subtask finishes, the remaining tasks amount of time isn't sum.

Do anyone know how to fix this?

Thanks in advance.

Hello John.

I'll try what you've said, but I could make what I wanted using the
following formula:

ProjDateDiff([Comienzo del proyecto];[Fin]) & "'"

Regards.

Fambrius,
OK, whatever works best for you.

John

 

[John]

Hello again.

I have a problem.

If I create subtasks, then my formula doesn't work. It shows 0 and, once the
subtask finishes, the remaining tasks amount of time isn't sum.

Do anyone know how to fix this?

Thanks in advance.

Fambrius,
I'm sorry but I don't quite understand how the formula you posted
relates to your original request for summing up resource working time. I
also must confess that my only language is English so I don't understand
the arguments in your formula.

Beyond that, what field did you customize with your formula? What view
are you using the formula on? What exactly is the formula supposed to do?

John
Project MVP

Hello John.

I'll try what you've said, but I could make what I wanted using the
following formula:

ProjDateDiff([Comienzo del proyecto];[Fin]) & "'"

Regards.

Fambrius,
OK, whatever works best for you.

John

"John" <[email protected]> escribió en el mensaje
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.

Fambrius,
Take a look at either the Resource Usage or Task Usage views. The Task
Usage view will probably be best for showing what you want. If you
display the Work field as a column in the tabular data on the left, it
will be the sum of working time for each assignment (i.e. resource),
whereas the timescale data on the right will show working time for each
assignment broken down by time increments.

Hope this helps.
John
Project MVP

"John" <[email protected]> escribió en el mensaje
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

 

[JulieS]

Hello Fambrius,

Pardon me for jumping in. My guess is that your summary tasks are not
set to use the formula and are not calculating. Select the custom field
with the formula and Choose Tools > Customize> Fields. In the Customize
Field dialog box select the option "Use formula" under the "Calculation
for task and group summary rows."

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

Hello again.

I have a problem.

If I create subtasks, then my formula doesn't work. It shows 0 and,
once the subtask finishes, the remaining tasks amount of time isn't
sum.

Do anyone know how to fix this?

Thanks in advance.

Hello John.

I'll try what you've said, but I could make what I wanted using the
following formula:

ProjDateDiff([Comienzo del proyecto];[Fin]) & "'"

Regards.

Fambrius,
OK, whatever works best for you.

John

"John" <[email protected]> escribió en el mensaje
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.

Fambrius,
Take a look at either the Resource Usage or Task Usage views. The
Task
Usage view will probably be best for showing what you want. If you
display the Work field as a column in the tabular data on the
left, it
will be the sum of working time for each assignment (i.e.
resource),
whereas the timescale data on the right will show working time for
each
assignment broken down by time increments.

Hope this helps.
John
Project MVP

"John" <[email protected]> escribió en el mensaje
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

 

[Fambrius]

Hello JulieS.

As it wasn't possible to select the summary options, I didn't think that I
had to select Formula. I've done it and now it works ok

Thanks again.

Hello Fambrius,

Pardon me for jumping in. My guess is that your summary tasks are not set
to use the formula and are not calculating. Select the custom field with
the formula and Choose Tools > Customize> Fields. In the Customize Field
dialog box select the option "Use formula" under the "Calculation for task
and group summary rows."

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

Hello again.

I have a problem.

If I create subtasks, then my formula doesn't work. It shows 0 and, once
the subtask finishes, the remaining tasks amount of time isn't sum.

Do anyone know how to fix this?

Thanks in advance.

Hello John.

I'll try what you've said, but I could make what I wanted using the
following formula:

ProjDateDiff([Comienzo del proyecto];[Fin]) & "'"

Regards.

Fambrius,
OK, whatever works best for you.

John

"John" <[email protected]> escribió en el mensaje
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.

Fambrius,
Take a look at either the Resource Usage or Task Usage views. The
Task
Usage view will probably be best for showing what you want. If you
display the Work field as a column in the tabular data on the left,
it
will be the sum of working time for each assignment (i.e. resource),
whereas the timescale data on the right will show working time for
each
assignment broken down by time increments.

Hope this helps.
John
Project MVP

"John" <[email protected]> escribió en el mensaje
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

 

[JulieS]

You're welcome Fambrius and thanks for the feedback.

Julie

Hello JulieS.

As it wasn't possible to select the summary options, I didn't think
that I had to select Formula. I've done it and now it works ok

Thanks again.

Hello Fambrius,

Pardon me for jumping in. My guess is that your summary tasks are not
set to use the formula and are not calculating. Select the custom
field with the formula and Choose Tools > Customize> Fields. In the
Customize Field dialog box select the option "Use formula" under the
"Calculation for task and group summary rows."

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

Hello again.

I have a problem.

If I create subtasks, then my formula doesn't work. It shows 0 and,
once the subtask finishes, the remaining tasks amount of time isn't
sum.

Do anyone know how to fix this?

Thanks in advance.

"John" <[email protected]> escribió en el mensaje
Hello John.

I'll try what you've said, but I could make what I wanted using
the
following formula:

ProjDateDiff([Comienzo del proyecto];[Fin]) & "'"

Regards.

Fambrius,
OK, whatever works best for you.

John

"John" <[email protected]> escribió en el mensaje
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.

Fambrius,
Take a look at either the Resource Usage or Task Usage views.
The Task
Usage view will probably be best for showing what you want. If
you
display the Work field as a column in the tabular data on the
left, it
will be the sum of working time for each assignment (i.e.
resource),
whereas the timescale data on the right will show working time
for each
assignment broken down by time increments.

Hope this helps.
John
Project MVP

"John" <[email protected]> escribió en el mensaje
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