Milliseconds in a Pivot Table

R

Ryan

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.
 
D

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.
 
D

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.)
 
Top