How to summarise time values in a Pivot table?

[vergab]

Hi there,
I try to create a Pivot table from these data:

[TABLE="width: 304"]
<tbody>[TR]
[TD]Area


[/TD]
[TD]TT[/TD]
[TD]Site[/TD]
[TD]Work time[/TD]
[TD]Month[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]INC000000177407[/TD]
[TD="align: right"]1687[/TD]
[TD="align: right"]25:08:51[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]INC000000183547[/TD]
[TD="align: right"]2771[/TD]
[TD="align: right"]24:24:38[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]INC000000132330[/TD]
[TD="align: right"]1075[/TD]
[TD="align: right"]19:31:04[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]INC000000231001[/TD]
[TD="align: right"]2709[/TD]
[TD="align: right"]18:31:27[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]INC000000254227[/TD]
[TD="align: right"]4079[/TD]
[TD="align: right"]27:04:10[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]INC000000255227[/TD]
[TD="align: right"]5707[/TD]
[TD="align: right"]31:48:56[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]INC000000259337[/TD]
[TD="align: right"]2732[/TD]
[TD="align: right"]21:58:03[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]C [/TD]
[TD]INC000000276814[/TD]
[TD="align: right"]2709[/TD]
[TD="align: right"]22:55:13[/TD]
[TD="align: right"]8[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col></colgroup>[/TABLE]

I would like to summerise the working time values like this:
Area A - 84:01:57, and so on.
But it shows the result with the quantity of Area A (3). How should I do it?

 

[MattVizor]

Re: How to summerise time values in a Pivot table?

but then you can't change the Pivottable to a sum from within the field list?
Apologies if I am preaching to the converted, but if you click on the dropdown list next to, what I assume is called, Count of Work time, then select field value settings, are you able to select 'Sum'?