Duration more than 24hrs

[Idkpowerbi]

And power bi recognizes duration above 24 hours as

@Greg_Deckler posted some years back about using Chelsie Eiden's duration. Here is the link for it as well. 

https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/td-p/79363...

I am not sure how to implement this though majorly because my initial format is not in total seconds type. It's in the regular text format that power bi recognizes for duration more than 24hrs.  I went through multiple community solutions and nothing worked. Please help

[Idkpowerbi]

@v-zhangti I think it's possible for me to use Greg's solution if I can convert this format into total duration in seconds. Can you help me do that. 

[v-zhangti]

Hi, @Idkpowerbi 

You could add a custom column.

=[Time] - #datetime(1899, 12, 31, 0, 0, 0)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Idkpowerbi]

Hi. Thanks for answering. I am sorry for not being clearer earlier. Your solution gives me in terms of days which is a common problem in powerbi when we want to visualize durations more than 24 hours. I am attaching a model visual which I will be using. This was made in excel. I will be needing to show the number of hours and minutes instead of number of days. 

Edit: also I see that the custom column is being recognised as text by power bi, which is another problem which I have seen in other answers.