title: Calculate per minute averages from data by seconds
body: <p>I have three columns, for example:</p>
  
  <pre>   A              B           C
   COUNT   TIMESTAMP           TYPE
       1   2014-12-01-00.00.01   A
       8   2014-12-01-00.00.01   B
       3   2014-12-01-00.00.02   A
      78   2014-12-01-00.00.02   C
      12   2014-12-01-00.00.02   A</pre>
  
  <p>and so on for the full day (i.e. 1st Dec 2014).</p>
  
  <p>For all <code>TYPE</code> I need to calculate average <code>COUNT</code>on a 'per minute' (from <code>TIMESTAMP</code>) basis.</p>
  
  <p>Is there a way to do it?  </p>
  
  <p>The problem is that in column B there is no fixed pattern i.e. there could be missing seconds as well. I have used PivotTables/Charts to get the data I want but I need to do per minute average analysis as well and not just per seconds.   </p>