title: How to convert an interval like "1 day 01:30:00" into "25:30:00"?
body: <p>I need to add some intervals and use the result in Excel.  </p>
  
  <p>Since  </p>
  
  <pre><code>sum(time.endtime-time.starttime)
  </code></pre>
  
  <p>returns the interval as "1 day 01:30:00" and this format breaks my Excel sheet, I thought it'd be nice to have the output like "25:30:00" but found no way to do it in the PostgreSQL documentation.  </p>
  
  <p>Can anyone here help me out?</p>