I'm creating a spreadsheet to track my 2 son's middle school track stats.
For the timed events, I've captured the seconds and milliseconds in the
following custom format (MM:SS.00). The data appears as I want it in the
spreadsheet.

The issue is when I run a pivot table on the data. The pivot table rounds
the time to the nearest second. :(

I've made sure the the pivot table field is set for the same custom format.

I'm running Excel 2002.

Any ideas or thoughts would be appreciated.