Forum Discussion
Numbers convert into duration
I have number type column, i want to convert those numbers into duration format : 00:00:00. How to do that ? Thanks
Haha I understand it is a number. What I'm asking is what is that number? Days? Seconds? In order to properly calculate duration we can do some simple math to transform it but if you don't know what the granularity is then you have bigger problems than the duration being inaccurate.
I am using Duration = FORMAT(Test[Duration_avg]/60, "hh:MM:SS"), will test if it works well.