Hours (Text) greater than 24 when converted to duration type throws error.

[habulbul]

Hello Everyone,

I'm trying to represent a total time value, strictly in hours and minutes, powerBI throws an error.
I'd assume the Duration type to be programmed separately to the Time type but both think 23:59 is the absolute limit for how much time a cell can have.
I had instances where the hours are well above 100 but haven't had the need to make a report on average time for these , now I need to use this information to make a chart.
Indeed I could work on excel to modify the values to be more suitable, however the excel itself is exported from one of our tools, thus would require editing every single time I extract a new report.
I'm hoping to have this resolved through powerBI to have the raw data automatically converted from text to hour:minutes.

Thanks in advance for any attention 🙂

Please see below the values:

[amitchandak]

@habulbul , Refer if this can help

https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

[habulbul]

Hello Amit, Thank you for the response. I've checked the post, also downloaded the pbix file to see if I can extract any formula, however I'm at a loss.
My knowledge on powerBI is at a "learn by trial" level so I might be missing something, though I'm not certain what to do with the information within that post.
I have already reviewed several other posts prior to posting my question, however many of those were referring to days or  calculating a total.
The general idea I've obtained so far on what could be a possible solution, is that there ought to be a formula which when inserted creates a new column in total hours and not hours of the day.
I might also be totally off.

Also, the values are as text, so there's that as well.

[v-easonf-msft]

Hello, @habulbul

Have you referred to this related post?

https://community.powerbi.com/t5/Desktop/Duration-more-than-24-hours-transform-duration-column-to-DD...

Best regards
Community Support Team _ Eason

[habulbul]

Thank you.

Unfortunately, after changing the column name I got the following error:

Expression.Error: There weren't enough elements in the enumeration to complete the operation.
Details:
[List]

When I remove the last arggument, I get the following error:

Expression.Error: 3 arguments were passed to a function which expects 4.
Details:
Pattern=
Arguments=[List]