Add a column to your data.
Use a formula that returns the value in the time cell:
=a2
(say)

But format that cell as General.

Then use that in your pivottable. After you've built the pivottable, format
that field to show the time (including the tenths of seconds).



Alex wrote:

I am trying to enter swimming race times in excel. I am using the format:
m:ss.0, but when i put the data into a pivot table all of the tenths become
zeros.

HELP

--

Dave Peterson