This content has been marked as final. Show 3 replies
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.