Creating Calculations Within a Field

[MinhPhan]

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

 

[JulieD]

Hi

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

Cheers
JulieD

 

[MinhPhan]

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]

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]

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).