title: Computing Average In MM:SS in excel
body: <p>Input: Minutes:Seconds
  Output: Average in Minutes:Seconds</p>
  
  <p>I currently have a sheet where we put in handle times for calls. We want to compute the average handling time in minutes:seconds. Now, currently we have minutes in Column A and seconds in Column B. In Column C, I convert A&amp;B to total seconds. In Column D, I use =AVERAGE(C1:C6) to compute for average. </p>
  
  <p>Question: Do we have an easier way to doit? Specifically, is there any formula that will allow me to simply input Minutes:Seconds in a single column and have the average in Minutes:Seconds to be calculated?</p>