I came across a scenario in which i need to convert total number of seconds into hours minutes and second, so after searching and trying different things i end up with the following visual studio expression which give me my desired result.
=FLOOR(SUM(Fields!Travel.Value)/3600) & ":"
& RIGHT("0"&((SUM(Fields!Travel.Value) MOD
3600)/60),2) & ":"
& Right("0" &
RIGHT("0"&(SUM(Fields!Travel.Value) MOD 3600),2) MOD 60,2)
In Above Expression you need to replace Travel with your tmp table field which contains total no. of second.
No comments:
Post a Comment