Hi there,
I try to create a Pivot table from these data:
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>
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?
I try to create a Pivot table from these data:
Area | TT | Site | Work time | Month |
A | INC000000177407 | 1687 | 25:08:51 | 2 |
B | INC000000183547 | 2771 | 24:24:38 | 3 |
B | INC000000132330 | 1075 | 19:31:04 | 3 |
C | INC000000231001 | 2709 | 18:31:27 | 5 |
A | INC000000254227 | 4079 | 27:04:10 | 7 |
A | INC000000255227 | 5707 | 31:48:56 | 7 |
C | INC000000259337 | 2732 | 21:58:03 | 7 |
C | INC000000276814 | 2709 | 22:55:13 | 8 |
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>
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?