Sep 17 2020 08:21 PM
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.
Sep 17 2020 09:27 PM
@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.
Sep 18 2020 01:47 AM