View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pbv pbv is offline
external usenet poster
 
Posts: 1
Default Why do I lose hundredths when summing elapsed times in a pivot tab

I am logging individual race times by person by date by race. I am
formatting these as elapsed times using the number format [mm]:ss.00, which
works fine. However, when use a pivot table (as a step toward graphing the
times), the pivot table rounds the elapsed times to the nearest second. I
would like to display the hundredths in the Pivot table and in any related
Pivot Table graphs. Any suggestions?