Tuesday, 22 October 2013

Displaying the number of seconds in hh:mm:ss format

Original analytic.


.


Added a computed measure on the measure that shows the number of seconds as follows:

cast(floor(({Seconds})/3600) as varchar(10))+':'+
cast(floor((({Seconds})%3600)/60) as varchar(10))+':'+
cast(((({Seconds})%3600)%60) as varchar(10))



Final output:


.

No comments:

Post a Comment