3 Replies Latest reply on Feb 3, 2019 10:38 PM by Shinichiro Murakami

    Adding symbol between Numbers

    mursid rahman

      Hi,

       

      I wanna try to add ':' between numbers that I have. To make it looks like time. The problem is that the length of the integers differ but thankfully it has only 2 lengths which are 5 and 6.

       

      Transaction+Time.PNG

       

      E.g Row 3. 14552 which has length 5. I wanna turn into 1:45:52.

      E.g Last row. 221903 which has length 6. I wanna turn into 22:19:03

       

      Your help is greatly appreciated!

       

      Thank you in advance.

       

      Cheers,

      M.R