Count the total mins either in the table or as cal field on your report. Here we call it TimeSpan   Datediff(minute,[@field:StartTime], [@field:EndTime])   Then in the aggregation use that to get the total:   CAST ((SUM(TimeSpan)/60) AS VARCHAR(6)) + ':' +CAST ((SUM(TimeSpan)%60) AS VARCHAR(2))