Using PivotTable to calculate average duration

Copper Contributor

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. 

 

Ivy_Hai_1-1600398989047.png

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

Ivy_Hai_2-1600399010038.png

 

 

2 Replies

@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.

@Ivy_Hai 

As variant you may use calculated field and use it in PivotTable

image.png