9 Replies Latest reply on Jul 26, 2018 11:15 AM by Matthew Maling

    Convert Decimal to HH:MM:SS

    Matthew Maling

      Hey,

       

      I am trying to format a number in to HH:MM:SS.

       

      The number is 2.33 and it should be reading 2:20:22.

       

      Just by adjusting the format is making this 8:00:00.

       

      I need to know if there is way to convert a decimal where the hour is before the decimal and the minutes and seconds are represented after the decimal.

       

      Thanks!