Keep the hours over 24

[Anonymous]

Hi,
I'm trying to convert the working and idle time into power query, but somehow it cant show the exact value from my excel file. 
For example below, i want the 109H 30Min shown in my Power BI. So that i can make stacked bar chart with percentage of each month.
Can someone help me?

[v-yalanwu-msft]

Hi， @Anonymous ；

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

The main reason for this problem is that you need to create a new column in Excel because of the automatic conversion of excel formats:

=B2*24

Then it will change the hour times ,you could convert in power query.

The final output is shown below:

Or better yet, use the formula directly in Excel to convert it to the format you want and import it into PowerBI
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , I doubt you can show time on Y-axis or in this format.