SSRS 2005: Adding times and showing in the total time column

• venugopal.sjce

  Valued Member

  Points: 66

  More actions

  March 10, 2010 at 1:47 am

  #216471

  Hello,

  I have a column which stores time in h:mm:ss format.

  I need to show the sum of this column in the total.

  example, the first row has 2:50:00

  and 2nd row has 2:40:30,

  the sum should be 5:30:30.

  how can we do this using expressions?

  Thanks,

  Venu

• venugopal.sjce

  Valued Member

  Points: 66

  More actions

  March 10, 2010 at 7:18 am

  #1131376

  I found out the solution. I wrote a C# function and referenced it in the my report.

  The following link helped me to accomplish this.

  http://msdn.microsoft.com/en-us/library/ms153561.aspx