Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 TOTAL TIME

Author  Topic 

Blessed1978
Yak Posting Veteran

97 Posts

Posted - 2014-05-14 : 12:53:07
I am having problems adding the totals for my time field in RS.

so if i have 3:10:25
2:55:10

may total time should be 6:05:35 i am using the below expression
= Format(DateAdd("s", SUM(Fields!Total_TIME_Seconds.Value), "00:00:00"), "HH:mm:ss")

but i keep getting the incorrect TOTAL TIME
   

- Advertisement -