title: SSRS: Summing TimeSpan values in a report
body: <p>I have a report and a datasource where one of the columns are of type TimeSpan. The TimeSpan value appears to display correctly in the report when I use <code>Fields!TheTime.Value</code>, no problem there.</p>
  
  <ul>
  <li>07:02:00</li>
  <li>05:41:00</li>
  </ul>
  
  <p>But I would like to do a Sum on those values to get the total time of a group. In C# and such I can of course do a TimeSpan + another TimeSpan, so I know they can be added. I tried</p>
  
  <pre><code>=Sum(Fields!TheTime.Value)
  </code></pre>
  
  <p>But it ends up printing out as a long number of some sort. For example for the outputted times above, I would get <code>457800000000</code> as the sum. And what is that even supposed to be?</p>
  
  <p>Anyways, how can I sum timespan values in a report? For the above timespans I would like to end up with <code>12:43:00</code> as the sum. Unless my head failed me at math once again... but you get the idea :p</p>