I don't know why the fractional part of the seconds are lost, but you could work
around it.

Either format that column of times as general, then run your pivottable and
format those pivottable columns as [mm].ss.00. But if you change the raw data
columns back to time formatting, the next time you update the pivottable, you'll
lose those fractions.

I think I'd add another column and just use simple formula:
=A2
And format as general and drag down.

Then use these helper columns as the basis for you pivottable.

And format the pivottable results as: [mm].ss.00

It seemed to behave nice for me--even after refreshing the pivottable.

(I used xl2003 to test.)


the swimmer wrote:

Hi Fellow Excel puzzlers

I create a pivot table and extract time data which has been custom
formatted to show minutes seconds and two decimal places of seconds
(i.e. down to hundreths) however the pivot table has then lost the
tenths and hundredths of a second and shows all times with the tenths
and hundreths as ".00" why is this happening is it a hidden rounding?
can it not handle time to this accuracy when translating data into a
pivot table any thoughts or knowledge on the subject appreciated.

--
the swimmer
------------------------------------------------------------------------
the swimmer's Profile: http://www.excelforum.com/member.php...o&userid=29863
View this thread: http://www.excelforum.com/showthread...hreadid=495735

--

Dave Peterson