Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

answered 2013-12-18 13:11:01 +0200

ROSt52 gravatar image

I don't know how your data are structure before you created the pivot table and assumed that you have such a structure: image description

The time format is hh:mm:ss

Next I created the following pivot table: image description

To the result looks correct.

If this is not the answer you need, please specify how your data are structured and what exactly you do when you try to create the pivot table.