Forum Discussion
Solved
Time duration not able to covert to hh:mm
we ahve the downloaded data for the operation time in text form example 03:45 , if we load the data in the Power query data not converted to duration if the value beyound 24:00 , shows error . if we ...
my suggestion would be to convert the HH:MM to a regular number ( split the value by ":" and then divide the minutes by 60. then add it again). This way you get from 26:40 number 26,66. Then you can sum it in power bi and work with it in visuals. Next you could probably convert the number in a measure to display the number in the format you want (26:40 again...)
Hi krajivga
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you