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

    Adding symbol between Numbers

    mursid rahman



      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.




      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.