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