Using PivotTable to calculate average duration

Question

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 manually, It will work)

sample data attached.

already make sure the 'number format' is set to time.

riny_van_eekelen · Answer

Ivy_Hai&nbsp;The formula you used to display duration created texts.&nbsp;Simply use =D2-C2 and custom format as mm:ss&nbsp;&nbsp;Now you can refresh the pivot table to display average call duration per day. See attached.

sergeibaklan · Answer

Ivy_Hai&nbsp;
As variant you may use calculated field and use it in PivotTable

Forum Discussion

Using PivotTable to calculate average duration

2 Replies

Resources