Creating Calculations Within a Field

Hello,

I have an Activity field with various activities and I would like to
calculate the time values between these activities.

For example:
Activity (Field) Time (Avg)
Stand 12:00
Run 13:00
Stop 13:30

I would like to add a calculation within Activity that is Stop - Stand. I
greatly appreciate any help. Thanks!

Minh

Hi

assume your example is in cells A1:B4
the formula you're looking for is B4-B2

Cheers
JulieD


"MinhPhan" wrote in message
...
Hello,

I have an Activity field with various activities and I would like to
calculate the time values between these activities.

For example:
Activity (Field) Time (Avg)
Stand 12:00
Run 13:00
Stop 13:30

I would like to add a calculation within Activity that is Stop - Stand. I
greatly appreciate any help. Thanks!

Minh

I should have mentioned that I am working with a pivot table. Is it possible
to create a formula within a field?

For example:
Activity (Field) Time (Avg)
Stand 12:00
Run 13:00
Stop 13:30

I would like to add a calculation within Activity that is Stop - Stand. I
greatly appreciate any help. Thanks!

Minh


"JulieD" wrote:

Hi

assume your example is in cells A1:B4
the formula you're looking for is B4-B2

Cheers
JulieD


"MinhPhan" wrote in message
...
Hello,

I have an Activity field with various activities and I would like to
calculate the time values between these activities.

For example:
Activity (Field) Time (Avg)
Stand 12:00
Run 13:00
Stop 13:30

I would like to add a calculation within Activity that is Stop - Stand. I
greatly appreciate any help. Thanks!

Minh

Hi

you can add calculated fields to pivot tables, on the pivot table toolbar,
click on the pivot table icon and choose formula ... see how you go.

Cheers
JulieD

"MinhPhan" wrote in message
...
I should have mentioned that I am working with a pivot table. Is it
possible
to create a formula within a field?

For example:
Activity (Field) Time (Avg)
Stand 12:00
Run 13:00
Stop 13:30

I would like to add a calculation within Activity that is Stop - Stand. I
greatly appreciate any help. Thanks!

Minh


"JulieD" wrote:

Hi

assume your example is in cells A1:B4
the formula you're looking for is B4-B2

Cheers
JulieD


"MinhPhan" wrote in message
...
Hello,

I have an Activity field with various activities and I would like to
calculate the time values between these activities.

For example:
Activity (Field) Time (Avg)
Stand 12:00
Run 13:00
Stop 13:30

I would like to add a calculation within Activity that is Stop - Stand.
I
greatly appreciate any help. Thanks!

Minh

I could see how I would calculate between various fields, but I could not set
up a calculation within the field itself. Did I overlook something?

I am also trying to group the values, but it does not allow for subtraction
(only summing).

"JulieD" wrote:

Hi

you can add calculated fields to pivot tables, on the pivot table toolbar,
click on the pivot table icon and choose formula ... see how you go.

Cheers
JulieD

"MinhPhan" wrote in message
...
I should have mentioned that I am working with a pivot table. Is it
possible
to create a formula within a field?

For example:
Activity (Field) Time (Avg)
Stand 12:00
Run 13:00
Stop 13:30

I would like to add a calculation within Activity that is Stop - Stand. I
greatly appreciate any help. Thanks!

Minh


"JulieD" wrote:

Hi

assume your example is in cells A1:B4
the formula you're looking for is B4-B2

Cheers
JulieD


"MinhPhan" wrote in message
...
Hello,

I have an Activity field with various activities and I would like to
calculate the time values between these activities.

For example:
Activity (Field) Time (Avg)
Stand 12:00
Run 13:00
Stop 13:30

I would like to add a calculation within Activity that is Stop - Stand.
I
greatly appreciate any help. Thanks!

Minh

Hi

can you post a 5 line example of the data that the pivot table is based on
....
please don't attach a workbook just type it out the format
.......A........B.............C..............D
1....data...data........data..........data

thanks - as i'ld like to try out a few ideas

Cheers
JulieD

"MinhPhan" wrote in message
...
I could see how I would calculate between various fields, but I could not
set
up a calculation within the field itself. Did I overlook something?

I am also trying to group the values, but it does not allow for
subtraction
(only summing).

"JulieD" wrote:

Hi

you can add calculated fields to pivot tables, on the pivot table
toolbar,
click on the pivot table icon and choose formula ... see how you go.

Cheers
JulieD

"MinhPhan" wrote in message
...
I should have mentioned that I am working with a pivot table. Is it
possible
to create a formula within a field?

For example:
Activity (Field) Time (Avg)
Stand 12:00
Run 13:00
Stop 13:30

I would like to add a calculation within Activity that is Stop - Stand.
I
greatly appreciate any help. Thanks!

Minh


"JulieD" wrote:

Hi

assume your example is in cells A1:B4
the formula you're looking for is B4-B2

Cheers
JulieD


"MinhPhan" wrote in message
...
Hello,

I have an Activity field with various activities and I would like to
calculate the time values between these activities.

For example:
Activity (Field) Time (Avg)
Stand 12:00
Run 13:00
Stop 13:30

I would like to add a calculation within Activity that is Stop -
Stand.
I
greatly appreciate any help. Thanks!

Minh

Here is an example of the data:
Name Activity Time
Jason Walking 0:30:00
Jason Running 0:15:00
Jason Dumbels 0:18:00
Jason Bench 0:13:00
Mark Walking 0:30:00
Mark Running 0:15:00
Mark Dumbels 0:18:00
Mark Bench 0:13:00

In the pivot table, I would like to add a new activity and it is Walking
minus Running. The pivot table will then be:

Activity Total
Bench 0:26:00
Dumbels 0:36:00
Running 0:30:00
Walking 1:00:00
Walking - Running 0:30:00

Thanks for looking into this!


"JulieD" wrote:

Hi

can you post a 5 line example of the data that the pivot table is based on
....
please don't attach a workbook just type it out the format
.......A........B.............C..............D
1....data...data........data..........data

thanks - as i'ld like to try out a few ideas

Cheers
JulieD

"MinhPhan" wrote in message
...
I could see how I would calculate between various fields, but I could not
set
up a calculation within the field itself. Did I overlook something?

I am also trying to group the values, but it does not allow for
subtraction
(only summing).

"JulieD" wrote:

Hi

you can add calculated fields to pivot tables, on the pivot table
toolbar,
click on the pivot table icon and choose formula ... see how you go.

Cheers
JulieD

"MinhPhan" wrote in message
...
I should have mentioned that I am working with a pivot table. Is it
possible
to create a formula within a field?

For example:
Activity (Field) Time (Avg)
Stand 12:00
Run 13:00
Stop 13:30

I would like to add a calculation within Activity that is Stop - Stand.
I
greatly appreciate any help. Thanks!

Minh


"JulieD" wrote:

Hi

assume your example is in cells A1:B4
the formula you're looking for is B4-B2

Cheers
JulieD


"MinhPhan" wrote in message
...
Hello,

I have an Activity field with various activities and I would like to
calculate the time values between these activities.

For example:
Activity (Field) Time (Avg)
Stand 12:00
Run 13:00
Stop 13:30

I would like to add a calculation within Activity that is Stop -
Stand.
I
greatly appreciate any help. Thanks!

Minh

Hi

i was able to achieve this:
1) click on "bench" in the pivot table
2) choose pivot table (icon on the toolbar)
3) choose formulas
4) choose CALCULATED ITEM
5) called it WR
6) typed the formula
= Walking - Running

and clicked on OK

Cheers
JulieD
PS i'm using Ver 2003 not sure when this option was made available (never
done it before)

"MinhPhan" wrote in message
...
Here is an example of the data:
Name Activity Time
Jason Walking 0:30:00
Jason Running 0:15:00
Jason Dumbels 0:18:00
Jason Bench 0:13:00
Mark Walking 0:30:00
Mark Running 0:15:00
Mark Dumbels 0:18:00
Mark Bench 0:13:00

In the pivot table, I would like to add a new activity and it is Walking
minus Running. The pivot table will then be:

Activity Total
Bench 0:26:00
Dumbels 0:36:00
Running 0:30:00
Walking 1:00:00
Walking - Running 0:30:00

Thanks for looking into this!


"JulieD" wrote:

Hi

can you post a 5 line example of the data that the pivot table is based
on
....
please don't attach a workbook just type it out the format
.......A........B.............C..............D
1....data...data........data..........data

thanks - as i'ld like to try out a few ideas

Cheers
JulieD

"MinhPhan" wrote in message
...
I could see how I would calculate between various fields, but I could
not
set
up a calculation within the field itself. Did I overlook something?

I am also trying to group the values, but it does not allow for
subtraction
(only summing).

"JulieD" wrote:

Hi

you can add calculated fields to pivot tables, on the pivot table
toolbar,
click on the pivot table icon and choose formula ... see how you go.

Cheers
JulieD

"MinhPhan" wrote in message
...
I should have mentioned that I am working with a pivot table. Is it
possible
to create a formula within a field?

For example:
Activity (Field) Time (Avg)
Stand 12:00
Run 13:00
Stop 13:30

I would like to add a calculation within Activity that is Stop -
Stand.
I
greatly appreciate any help. Thanks!

Minh


"JulieD" wrote:

Hi

assume your example is in cells A1:B4
the formula you're looking for is B4-B2

Cheers
JulieD


"MinhPhan" wrote in message
...
Hello,

I have an Activity field with various activities and I would like
to
calculate the time values between these activities.

For example:
Activity (Field) Time (Avg)
Stand 12:00
Run 13:00
Stop 13:30

I would like to add a calculation within Activity that is Stop -
Stand.
I
greatly appreciate any help. Thanks!

Minh

Thanks Julie! This is exactly what I needed!

Minh

"JulieD" wrote:

Hi

i was able to achieve this:
1) click on "bench" in the pivot table
2) choose pivot table (icon on the toolbar)
3) choose formulas
4) choose CALCULATED ITEM
5) called it WR
6) typed the formula
= Walking - Running

and clicked on OK

Cheers
JulieD
PS i'm using Ver 2003 not sure when this option was made available (never
done it before)

"MinhPhan" wrote in message
...
Here is an example of the data:
Name Activity Time
Jason Walking 0:30:00
Jason Running 0:15:00
Jason Dumbels 0:18:00
Jason Bench 0:13:00
Mark Walking 0:30:00
Mark Running 0:15:00
Mark Dumbels 0:18:00
Mark Bench 0:13:00

In the pivot table, I would like to add a new activity and it is Walking
minus Running. The pivot table will then be:

Activity Total
Bench 0:26:00
Dumbels 0:36:00
Running 0:30:00
Walking 1:00:00
Walking - Running 0:30:00

Thanks for looking into this!


"JulieD" wrote:

Hi

can you post a 5 line example of the data that the pivot table is based
on
....
please don't attach a workbook just type it out the format
.......A........B.............C..............D
1....data...data........data..........data

thanks - as i'ld like to try out a few ideas

Cheers
JulieD

"MinhPhan" wrote in message
...
I could see how I would calculate between various fields, but I could
not
set
up a calculation within the field itself. Did I overlook something?

I am also trying to group the values, but it does not allow for
subtraction
(only summing).

"JulieD" wrote:

Hi

you can add calculated fields to pivot tables, on the pivot table
toolbar,
click on the pivot table icon and choose formula ... see how you go.

Cheers
JulieD

"MinhPhan" wrote in message
...
I should have mentioned that I am working with a pivot table. Is it
possible
to create a formula within a field?

For example:
Activity (Field) Time (Avg)
Stand 12:00
Run 13:00
Stop 13:30

I would like to add a calculation within Activity that is Stop -
Stand.
I
greatly appreciate any help. Thanks!

Minh


"JulieD" wrote:

Hi

assume your example is in cells A1:B4
the formula you're looking for is B4-B2

Cheers
JulieD


"MinhPhan" wrote in message
...
Hello,

I have an Activity field with various activities and I would like
to
calculate the time values between these activities.

For example:
Activity (Field) Time (Avg)
Stand 12:00
Run 13:00
Stop 13:30

I would like to add a calculation within Activity that is Stop -
Stand.
I
greatly appreciate any help. Thanks!

Minh

you're welcome and thanks for the feedback

"MinhPhan" wrote in message
...
Thanks Julie! This is exactly what I needed!

Minh

"JulieD" wrote:

Hi

i was able to achieve this:
1) click on "bench" in the pivot table
2) choose pivot table (icon on the toolbar)
3) choose formulas
4) choose CALCULATED ITEM
5) called it WR
6) typed the formula
= Walking - Running

and clicked on OK

Cheers
JulieD
PS i'm using Ver 2003 not sure when this option was made available (never
done it before)

"MinhPhan" wrote in message
...
Here is an example of the data:
Name Activity Time
Jason Walking 0:30:00
Jason Running 0:15:00
Jason Dumbels 0:18:00
Jason Bench 0:13:00
Mark Walking 0:30:00
Mark Running 0:15:00
Mark Dumbels 0:18:00
Mark Bench 0:13:00

In the pivot table, I would like to add a new activity and it is
Walking
minus Running. The pivot table will then be:

Activity Total
Bench 0:26:00
Dumbels 0:36:00
Running 0:30:00
Walking 1:00:00
Walking - Running 0:30:00

Thanks for looking into this!


"JulieD" wrote:

Hi

can you post a 5 line example of the data that the pivot table is
based
on
....
please don't attach a workbook just type it out the format
.......A........B.............C..............D
1....data...data........data..........data

thanks - as i'ld like to try out a few ideas

Cheers
JulieD

"MinhPhan" wrote in message
...
I could see how I would calculate between various fields, but I could
not
set
up a calculation within the field itself. Did I overlook something?

I am also trying to group the values, but it does not allow for
subtraction
(only summing).

"JulieD" wrote:

Hi

you can add calculated fields to pivot tables, on the pivot table
toolbar,
click on the pivot table icon and choose formula ... see how you
go.

Cheers
JulieD

"MinhPhan" wrote in message
...
I should have mentioned that I am working with a pivot table. Is
it
possible
to create a formula within a field?

For example:
Activity (Field) Time (Avg)
Stand 12:00
Run 13:00
Stop 13:30

I would like to add a calculation within Activity that is Stop -
Stand.
I
greatly appreciate any help. Thanks!

Minh


"JulieD" wrote:

Hi

assume your example is in cells A1:B4
the formula you're looking for is B4-B2

Cheers
JulieD


"MinhPhan" wrote in message
...
Hello,

I have an Activity field with various activities and I would
like
to
calculate the time values between these activities.

For example:
Activity (Field) Time (Avg)
Stand 12:00
Run 13:00
Stop 13:30

I would like to add a calculation within Activity that is
Stop -
Stand.
I
greatly appreciate any help. Thanks!

Minh