title: How to Pivot with Daily Averages based on Times in Excel?
body: <p>This sheet contains a call log where there are a variable amount of calls per day, with a variable amount of call durations. 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. </p>
  
  <p>I am getting stuck on the pivot table where I want to gather a column of Average of Call Duration. Problem is I can't figure out a way for to tell Excel to calculate the average on the amount of calls per day. 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.</p>
  
  <p>Attaching same picture of values and how my pivot table currently looks.
  Any help would be greatly appreciated.</p>
  
  <p><strong>To summarize, I need to figure out</strong></p>
  
  <ol>
  <li>Tell Excel that the average is based on hh:mm:ss so it doesn't cause
  issues (if there's that chance) Tell Excel to calculate averages per
  day</li>
  </ol>
  
  <p>Thanks!
  <strong>(Using Excel for Mac 2011)</strong></p>
  
  <p><a href="http://s22.postimg.org/w1op2ue0h/Pivot.png" rel="nofollow">http://s22.postimg.org/w1op2ue0h/Pivot.png</a> (values of the table)
  <a href="http://s22.postimg.org/bt1bh4epd/Values.png" rel="nofollow">http://s22.postimg.org/bt1bh4epd/Values.png</a> (pivot from those values where you see avg duration 1442.00)</p>