title: How can I sum a column of large hours:mins:seconds figures in excel?
body: <p>Using MS Excel 2010.</p>
  
  <p>A column of hours, mins, secs e.g.</p>
  
  <pre><code>12345:34:34
  12345:34:34
  12345:34:34
  </code></pre>
  
  <p>Is totalled as </p>
  
  <pre><code>00000:00:00
  </code></pre>
  
  <p>The cells' format is set to [h]:mm:ss</p>
  
  <p>Can anyone suggest a way of getting the correct answer please?
  I've tried =a1+a2+a3 as well as =sum(a1:a3)</p>