| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
loss of accuracy in pivot table
Hi Fellow Excel puzzlers I create a pivot table and extract time data which has been custom formatted to show minutes seconds and two decimal places of seconds (i.e. down to hundreths) however the pivot table has then lost the tenths and hundredths of a second and shows all times with the tenths and hundreths as ".00" why is this happening is it a hidden rounding? can it not handle time to this accuracy when translating data into a pivot table any thoughts or knowledge on the subject appreciated. -- the swimmer ------------------------------------------------------------------------ the swimmer's Profile: http://www.excelforum.com/member.php...o&userid=29863 View this thread: http://www.excelforum.com/showthread...hreadid=495735 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
| pivot table created from another pivot table | Excel Worksheet Functions | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
Threaded Mode
