Hi Alex,
You're telling Excel to round off the time to tenths of a second.

Try m:ss.000
It's the most decimal places Excel will display for time.

John


"Alex" wrote in message ...
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