Excel, Pivot table and total time formatting

[QMYork]

I am working a with a large spreadsheet that deals with elapsed or total time (e.g., 2:45:30 means 2 hours 45 minutes and 30 seconds NOT the actual time of day; 2:45 and 30 seconds AM) My column is formatted for TOTAL time but when I create a pivot table (PT) from the data the formatting is automatically changed to the time of day format where 1:30 is considered to be 30 minutes after 1 am. I can't get the correct formatting to transfer to the PT nor can I reformat the data in the PT.



Any thoughts?

Advice?

Tips?

 

[Joe4]

Duplicate to: Excel, Pivot table and total time formatting

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.