Seconds 2 HHMMSS

Great Wouter!

Thanks for your post, it helped me a lot. Let me return the favor by making an addition. What I noticed is that you had to make multiple measures in order to create the one measure you want. Below you can find my DAX formula, in which you only need one input variable in seconds, in order to create the measure you want in HH:MM:SS format. You do not have to make several other measures. I know the formula can be made less complex, but hey, it works.

The only thing you have to do, is replace [Input variable in seconds] into a variable of your choice. You can use the find/replace option in Word for this.

Measure in HH:MM:SS format =

IF(         CONCATENATE (IF ( LEN ( INT ( [Input variable in seconds] / 3600 )  )     = 1;CONCATENATE ( "0"; INT ( [Input variable in seconds] / 3600 )       );CONCATENATE ( ""; INT ( [Input variable in seconds] / 3600 )        ));CONCATENATE ( ":"; CONCATENATE ( IF ( LEN ( INT ( MOD( [Input variable in seconds] - ( INT ( [Input variable in seconds] / 3600 )  * 3600 );3600 ) / 60) ) = 1;CONCATENATE ( "0"; INT ( MOD( [Input variable in seconds] - ( INT ( [Input variable in seconds] / 3600 )  * 3600 );3600 ) / 60)   );CONCATENATE ( ""; INT ( MOD( [Input variable in seconds] - ( INT ( [Input variable in seconds] / 3600 )  * 3600 );3600 ) / 60)     )); CONCATENATE ( ":"; IF ( LEN ( ROUNDUP(MOD ( MOD( [Input variable in seconds] - ( INT ( [Input variable in seconds] / 3600 )  * 3600 );3600 ); 60 );0) )   = 1;CONCATENATE ( "0"; ROUNDUP(MOD ( MOD( [Input variable in seconds] - ( INT ( [Input variable in seconds] / 3600 )  * 3600 );3600 ); 60 );0)    );CONCATENATE ( ""; ROUNDUP(MOD ( MOD( [Input variable in seconds] - ( INT ( [Input variable in seconds] / 3600 )  * 3600 );3600 ); 60 );0) )) ) ) )) = "::"

            ;BLANK()

            ;CONCATENATE (IF ( LEN ( INT ( [Input variable in seconds] / 3600 )  )     = 1;CONCATENATE ( "0"; INT ( [Input variable in seconds] / 3600 )       );CONCATENATE ( ""; INT ( [Input variable in seconds] / 3600 )        ));CONCATENATE ( ":"; CONCATENATE ( IF ( LEN ( INT ( MOD( [Input variable in seconds] - ( INT ( [Input variable in seconds] / 3600 )  * 3600 );3600 ) / 60) ) = 1;CONCATENATE ( "0"; INT ( MOD( [Input variable in seconds] - ( INT ( [Input variable in seconds] / 3600 )  * 3600 );3600 ) / 60)   );CONCATENATE ( ""; INT ( MOD( [Input variable in seconds] - ( INT ( [Input variable in seconds] / 3600 )  * 3600 );3600 ) / 60)     )); CONCATENATE ( ":"; IF ( LEN ( ROUNDUP(MOD ( MOD( [Input variable in seconds] - ( INT ( [Input variable in seconds] / 3600 )  * 3600 );3600 ); 60 );0) )   = 1;CONCATENATE ( "0"; ROUNDUP(MOD ( MOD( [Input variable in seconds] - ( INT ( [Input variable in seconds] / 3600 )  * 3600 );3600 ); 60 );0)    );CONCATENATE ( ""; ROUNDUP(MOD ( MOD( [Input variable in seconds] - ( INT ( [Input variable in seconds] / 3600 )  * 3600 );3600 ); 60 );0) )) ) ) )))