software

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.

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,quot;mm:ss.00quot;)

Then, add that field to the pivot table.Ryan wrote:
gt; I'm creating a spreadsheet to track my 2 son's middle school track stats.
gt; For the timed events, I've captured the seconds and milliseconds in the
gt; following custom format (MM:SS.00). The data appears as I want it in the
gt; spreadsheet.
gt;
gt; The issue is when I run a pivot table on the data. The pivot table rounds
gt; the time to the nearest second.
gt;
gt; I've made sure the the pivot table field is set for the same custom format.
gt;
gt; I'm running Excel 2002.
gt;
gt; Any ideas or thoughts would be appreciated.--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.htmlAnother 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.)
Ryan wrote:
gt;
gt; I'm creating a spreadsheet to track my 2 son's middle school track stats.
gt; For the timed events, I've captured the seconds and milliseconds in the
gt; following custom format (MM:SS.00). The data appears as I want it in the
gt; spreadsheet.
gt;
gt; The issue is when I run a pivot table on the data. The pivot table rounds
gt; the time to the nearest second.
gt;
gt; I've made sure the the pivot table field is set for the same custom format.
gt;
gt; I'm running Excel 2002.
gt;
gt; Any ideas or thoughts would be appreciated.

--

Dave Peterson