title: excel sum time into hours (with base in seconds)
body: <p>My sheet holds a column with all cells having values in seconds (these can be very big numbers). What I want to do is to display (format) them summed up into minutes and hours. The "[hh]:mm:ss" format seems good, but it fails, because my cell contains seconds and excel expects it to be days.</p>
  
  <p>Example. My column looks like this (average time in seconds):</p>
  
  <pre><code>30378.92
  14142.78
  13837.00
  13787.44
  </code></pre>
  
  <p>after formatting it into time/[hh]:mm:ss I get:</p>
  
  <pre><code>729094:04:48 = 30378.92 * 24 ~= 729094.08
  339426:43:12
  332088:00:00
  330898:33:36
  </code></pre>
  
  <p>What I'd like to get is:</p>
  
  <pre><code>8:26:18 (30378 seconds = 8 hours + 26 mins + 18.9 secs)
  </code></pre>
  
  <p>Is it possible to force excel to treat '30378' as number of seconds instead of number of days? I know I can write '00:00:30378' into a cell - is this the only way?</p>