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
4356 is a number in that duration column. After apply for Duration from Change Data Type, it returns 4356,00:00:00
dkay84_PowerBI
9 years agoMicrosoft Employee
So is that seconds, minutes, days, etc.?
- ask9 years agoHelper III
- dkay84_PowerBI9 years agoMicrosoft Employee
What is the value before you changed the data type to duration?
- ask9 years agoHelper III
dkay84_PowerBI like 4356, it is a number. I think I might need to do match to get hh:mm:ss