Monday, 20 November 2017

SSRS: Convert Seconds into hours minutes & second H:M:S

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