Average Talk Time Per Category in a Pivot Table

[sherylt13]

Hello All, am trying to figure out how to simply calculate the average time per call, per category, in a pivot table. Seems it should be easy... am guessing it has to do with getting the time column in an appropriate format to then calculate, not successful yet. Any suggestions on calculating the average per category? Thanks for any assistance.

Sheryl

[Chance2]

Your call duration column is in a text format. Use Data --> Text to Columns on your duration column and then refresh your pivot (you'll need to format the pivot values also)

[sherylt13]

Thank you!