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
 Break down total time to Hours & minutes

Author  Topic 

Blessed1978
Yak Posting Veteran

97 Posts

Posted - 2014-04-13 : 15:45:01
need a RS expression that converts my total call time in hours and minutes example 1234 would be 20hrs and 56 minutes . or lets say my total is 3456.21 could be rounded to 58 hrs

thx

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-04-14 : 09:40:56
This one works for me:


=CStr(CInt(First(Fields!minutes.Value, "Minutes") / 60))
+ " hrs " +
CStr(Round(First(Fields!minutes.Value, "Minutes") mod 60 ,0))
+ " minutes"
Go to Top of Page
   

- Advertisement -