title: Report Builder Expression to SUM HH:MM:SS
body: <p>I am very new to SQL Server and SSRS and trying to create a report using a Matrix table within report builder.</p>
  
  <p>I want to sum the HH:MM:SS spent per job, per engineer, per day e.g. job 1 is 00:30:00, job 2 is 01:00:00 and job 3 is 02:45:00 so the total would be 04:15:00.</p>
  
  <p>I can use the query to produce the data and pull it together in an excel pivot table but not in a matrix table.</p>
  
  <p>Thanks - Andy</p>