Pivot Table

G

Gerry

I'm trying to set up a pivot table, the data in the
worksheet is custom and in the format of m:ss.00. This
displays correct in the cell, however in the data in the
formula bar shows it as hh:mm:ss and the hundreths of a
second have been rounded up to the nearest second. This
is also repeated in the cell in the pivot table. does
anyone know how to change this to display hundreths of a
second
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

loss of accuracy in pivot table 3
Pivot Tables and Filter Criteria Display 0
Formula to Look up values from a pivot table 1
Confusion over where user templates are stored in Word 1
Pivot Table date format 1
How can I get Pivot Tables to recognise time formatted data 1
pivot table data 2
MROUND time 3

Top