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
I am using Duration = FORMAT(Test[Duration_avg]/60, "hh:MM:SS"), will test if it works well.
My prediction is that you will get the time that corresponds with the fraction of your division:
You reallly need to go back and find out what your value represents, otherwise you are bound to create the most beautiful dashboards with highly unreliable information and you'll be in big trouble sooner or later.