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
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.
MarcelBeug
9 years agoCommunity Champion
4356 days, 4356 hours, 4356 minutes, 4356 seconds: