It depends what you need to do with the time in the pivot table, but
perhaps you could convert the time to text in the source data table. For
example, with times in column B, use the following formula:

=TEXT(B2,"mm:ss.00")

Then, add that field to the pivot table.

Gerry Bennett wrote:
The problem I have is that I have a worksheet with data as time, formatted
as m:ss.00 were 00 is hundredths of a second. I have noticed that the cell
shows the correct time say 1:34.96 but the formula bar shows it as rounded
up 1:35 this is also carried to the pivot table. so my data for printing is
wrong. Has anyone got an idea how I can over come this problem. thanks Gerry




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html