ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table (https://www.excelbanter.com/excel-discussion-misc-queries/23528-pivot-table.html)

Gerry

Pivot Table
 
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


All times are GMT +1. The time now is 08:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com