title: Cannot get hours to total over 24, eg 48 hours in hh:mm:ss output
body: <p>I am running a query to find out the total amount of time a user has been browsing for. Each browsing session is stored in the DB as seconds and I then sum the total seconds and convert it into <code>hh:mm:ss.</code> The problem is when I'm converting the seconds into <code>hh:mm:ss</code>. I want it to display for example <code>'78:20:00'</code> but I dont know how to get the code to total it like this. When it gets past 24 hrs the hrs column goes back to 00 because its into a day.</p>
  
  <p>The query I run to convert the time can be seen below:</p>
  
  <pre><code>SELECT Username,
         CONVERT(VARCHAR(12),DATEADD(SECOND,TotalTimeInSeconds,0),108) AS TotalHours
  FROM #TotalSessionTime
  </code></pre>