Forum Discussion
ask
9 years agoHelper III
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
ask
9 years agoHelper III
dkay84_PowerBI like 4356, it is a number. I think I might need to do match to get hh:mm:ss
dkay84_PowerBI
9 years agoMicrosoft Employee
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.