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