title: Total of minutes in SSRS
body: <p>I am creating a report in SSRS that shows the duration of phone calls.</p>
  
  <p>In my T-SQL script I am using: </p>
  
  <pre><code>CONVERT(VARCHAR,DATEADD(second,Call,0),108)AS[Call Duration]
  </code></pre>
  
  <p>which works nicely and shows the time as 00:03:20, for example.</p>
  
  <p>However when I create a table in SSRS and try to sum all the different time values it just says #error in the report. I need the report to be able to add these time values up so I can give a total per switchboard operator. So for example if officer x took three calls and they all lasted 3 minutes then I'd need the total to say 00:09:00</p>
  
  <p>Do you know of a way where I can display the total time spend rather than having to list each value separately? I can sum up the number of seconds for each call - so for example get a total of 540 seconds - but need to show this as hh:mm:ss</p>
  
  <p>Thanks</p>