2 Replies Latest reply on Jan 31, 2019 1:59 AM by mursid rahman

    Converting Integer to Time

    mursid rahman

      Hi,

       

      I need help in converting integer to time format. Currently my time dimension is in integer format. 24hour integer format. I need it to be converted into time format. Below is the snapshot for your reference.

       

      Transaction Time.PNG

       

      For example, the last row is 221903. I want to convert it to 22:19:03 and another example is the first row which is 14552 to 1:45:52.

       

      Thank you in advance.

       

      Cheers,

      M.R