Pivot: Min/Max of time - How to calculate amount of time between those two values?

[Darkzler]

Hi all,

I got this setup but can't figure out how to get the total amount of time from column C to column D.

Row Labels	Count of Shipment	Min of Tid	Max of Tid
Person A
Trp2	1	10:48:00	10:48:00
Trp3	4	12:29:00	16:52:00
Trp4	7	09:14:00	16:45:00
Trp1	7	09:24:00	16:44:00
Person B
Trp5	15	08:46:00	11:42:00
Trp6	26	09:22:00	13:32:00
Trp7	18	09:23:00	12:04:00

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

When I try to enter a calculated item it just says: "Multiple data fields of the same field are not supported when a PivotTable report has calculated items."

Any suggestions on how I get the difference between Max of Tid and Min of Tid?

 

[oldbrewer]

a helper column outside of the pivot with if (say) if(or(d6="",d6="Grand Total"),"",I6-h6)

 

[Darkzler]

Hi Oldbrewer,

That is my current solution but this pivot table will grow for each day that goes and to manually adjust this is a step I really try to avoid.

 

[oldbrewer]

the helper column can be 10000 rows deep - it will only pick up your min and max values - that is the point of error trapping out blanks and grand totals