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
Look at my first post on page 2: #duration(0,0,0,4356)
Unlike #date, #datetime and #datetimezone,
#duration allows individual elements (days, hours, minutes, seconds) to exceed the natural limits like <24 and <60.
You can even have a mix of positive and negative arguments, e.g. #duration(0,0,2,-90) gives 0.00:00:30 (2 minutes minus 90 seconds).
Thanks all, I have the right numbers by using the DAX in this post
https://community.powerbi.com/t5/Developer/formatting-time-value-to-hh-mm-ss/td-p/85249
And next question :
How to get the average of duration
For example :
0.0275 0:42:34 1:05:30 1:10:16 I want to get the average duration of above 4 durations in the table.