Hello,
I have a column with the number of seconds. Each rows have an integer (number of seconds) :
Sec
21
175
1652
71
102
I want to obtain a column with the traduction of this value in this format : HH:MM:SS
Is there a function to do this ? I've not found in the documentation...
Many thanks ! 🙂
Solved! Go to Solution.
There is no built in function for this. You can however accomplish this with a recipe step. I have attached a macro that contains this recipe step to accomplish this. The code for it is:
MERGE([PAD(FLOOR(DIVIDE(seconds, 3600)), 2, '0', left),PAD(FLOOR(MOD(seconds, 3600) / 60), 2, '0', left),PAD(MOD(seconds, 60), 2, '0', left)], ':')
where seconds is the column containing the seconds.
Hi @Eric Thomas? ,
Your solution is perfect ! 👍
Thank you !