Forum Discussion
Using PivotTable to calculate average duration
Had below error message when using PivotTable to calculate average duration. I've highlighted the formular i used to calculate this ducation. (If I create another new column and type the duration ...
Ivy_Hai The formula you used to display duration created texts. Simply use =D2-C2 and custom format as mm:ss
Now you can refresh the pivot table to display average call duration per day. See attached.