1 Reply Latest reply on Apr 12, 2018 9:19 AM by Matt Lutton

    Tableau 10.3: Convert Sum Mins to hh:mm:ss

    Bradley Smith

      Hi Team,

       

      I have looked at the article: Displaying Elapsed Time as HH:MM:SS or DD:HH:MM:SS | Tableau Software  but I am having issues converting from MINS to HH:MM:SS


      I tried, but I get weird results.

       

       

      STR(INT(SUM([ASPLT_INTRVL_AUX1_TM_MINS])/1440))

       

      + ":" +

       

      IF (INT(SUM([ASPLT_INTRVL_AUX1_TM_MINS])%1440/60))

      < 10 THEN "0" ELSE "" END + STR(INT(SUM([ASPLT_INTRVL_AUX1_TM_MINS])%1440/60))

       

      + ":" +

       

      IF INT(SUM([ASPLT_INTRVL_AUX1_TM_MINS])%60/60)

      < 10 THEN "0" ELSE "" END + STR(INT(SUM([ASPLT_INTRVL_AUX1_TM_MINS])%60/60))

       

       

      + ":" +

       

      IF INT(SUM([ASPLT_INTRVL_AUX1_TM_MINS]) %60 %60)

      < 10 THEN "0" ELSE "" END + STR(INT(SUM([ASPLT_INTRVL_AUX1_TM_MINS]) %60 %60))