Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Keep the hours over 24

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...
Need Help
Show and Tell
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

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.