![]() ![]() The current table shows Call Duration as hh:mm:ss, and I want to show the Average of Call Duration as mm:ss, especially in the chart.Īttaching same picture of values and how my pivot table currently looks. Problem is I can't figure out a way for to tell Excel to calculate the average on the amount of calls per day. I am getting stuck on the pivot table where I want to gather a column of Average of Call Duration. My goal is to create a chart that shows the number of calls as each day passes, but also show the average call duration per day. This sheet contains a call log where there are a variable amount of calls per day, with a variable amount of call durations.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |