title: SSRS Time HH:MM:SS Sum
body: <p>Can someone please help me with the following:</p>
  
  <p>I am trying to use an expression to calculate the sum of four different times.</p>
  
  <p>Queue Time, Ring Time, Hold Time, Talk Time</p>
  
  <p>These times are coming from a stored procedure as a single digit (5 seconds is simply value '5')</p>
  
  <p>I have used the following expression to convert this to HH:MM:SS (00:00:05)</p>
  
  <pre><code>=Format(DateAdd("s", SUM(Fields!quetime.Value), "00:00:00"), "HH:mm:ss")
  </code></pre>
  
  <p>Can someone please point me in the right direction to add these four times together and keep the HH:MM:SS format?</p>
  
  <p>I have tried the following but I get #Error:</p>
  
  <pre><code>=Sum(Format(DateAdd("s", SUM(Fields!quetime.Value), "00:00:00"), "HH:mm:ss") 
  + Format(DateAdd("s", SUM(Fields!ringtime.Value), "00:00:00"), "HH:mm:ss") 
  + Format(DateAdd("s", SUM(Fields!holdtime.Value), "00:00:00"), "HH:mm:ss")
  + Format(DateAdd("s", SUM(Fields!TalkTime.Value), "00:00:00"), "HH:mm:ss"))
  </code></pre>
  
  <p>(Broken up for on separate lines here for readability)</p>
  
  <p>I would like to do this within SSRS and not in SQL.</p>
  
  <p>Thanks in advance,
  Greg</p>