Keep the hours over 24

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.