| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table for 3 columns of elapsed times | Excel Discussion (Misc queries) | |||
| Formula to calculate elapsed time between certain dates and times | Excel Discussion (Misc queries) | |||
| can anyone help with times not coming across correctly in pivot t. | Excel Worksheet Functions | |||
| can anyone help with times not coming across correctly in pivot t. | Excel Worksheet Functions | |||
| Problem with times in pivot tables and graphs | Excel Discussion (Misc queries) | |||
Threaded Mode
