Milliseconds in a Pivot Table

[Guest]

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.

 

[Debra Dalgleish]

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.

 

[Dave Peterson]

Another option...

Create another column in your data table.

Use a formula that just returns the value in the other cell (=A2 for instance).

Format it as general.

Use this column in your pivottable.

But format it to include the milliseconds.

(You could just format the original column as General, too--but that makes it
more difficult to read.)