I have multiple columns in a table that find the difference between dates and times. These columns have a custom format of dd "days" hh "hours'. I have created Pivot Tables that show the average days and hours for each individual to complete a certain task. When creating a Pivot Chart, the average time shows to be one day less when using the custom format versus the number format. Any ideas as to why and if I can correct this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Custom Date Format in Pivot Chart
- Thread starter David_McG
- Start date
