title: Getting Average m:s:ms time in Google Sheets
body: <p>I am working on a Google Sheets file in order to get Track and Field Data.</p>
  
  <p>The times run by the athletes are:</p>
  
  <pre><code>1:58.66
  2:00.03
  2:00.31
  2:01.85
  2:03.07
  2:03.18
  2:03.57
  ... etc. 
  </code></pre>
  
  <p>In total I have 141 values. I have tried looking for functions to help me with this, but it seems as though these values are not accepted as numbers.</p>
  
  <p>I need the average of all 141 times.</p>