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
So is that seconds, minutes, days, etc.?
What is the value before you changed the data type to duration?
dkay84_PowerBI like 4356, it is a number. I think I might need to do match to get hh:mm:ss
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.