I have a Excel Spreadsheet that we have moved the data source from a Excel Table to a SQL DB. The data feeds an excel PivotTable which is then published on sharepoint.
Everything is working but the Time format is being imported as a precision time. (EX. 09:20:36.000000)Previously we were displaying the data in this format 9:20:36 AM. Outside of the Pivot Table I can easily use Cell Formatting to change the way the time is displayed. However, I am having trouble finding a way to change the formatting inside the Pivot Table to the old format. Any help or suggestions would be appreciated.

Kind Regards,

Paul