How can I show the difference between two columns in a Pivot Table

I have a pivot table that uses about 40,000 rows of time-stamps for the source data. The pivot table then has a column to find the "Min" time and a second column to find the "Max" time from the source data.

I want to have a 3rd column that shows the elapsed time between min and max time.... not sure how to accomplish this.

Not sure I follow...

The field list contains the column "M_Time". In the pivot table I dragged that in twice. Once to convert to "min", once to convert to "Max".

I followed your directions, I named my field "elapsed"
then used the formula:

"Max of M_Time" - "Min of M_Time"

The results all come out "#VALUE!".

Any tips? What am I doing wrong?

Ok, I tried using the single quotes instead of double, but now it says there is an error in my formula.

For the record:

Original column name: M_TIME

I dragged this into the pivot table twice, converted one to Min, one to Max. The exact names are:

Max of M_TIME2
Min of M_TIME

I tried the following formulas:

'Max of M_TIME2' - 'Min of M_TIME'
'Max of M_TIME' - 'Min of M_TIME'

both say error on formula when I click ok

The field list only allows me to add the original column, before the Min and Max are calculated...

Hi Guys

Has anyone got an answer to this exact problem as I have the same issue; DataSout has a Time field; in the pivot I created two columns MINTIME and MAXTIME.

How do I subtract MINETIME from MAXTIME?

Help!!!