Convert text to time format hh:mm:ss

Hi ntruong1994 

Download example PBIX file

Yes.  First you need to use Power Query to clean up the data by removing the h and m and converting the values to actual times.

Then after loading the data from Power Query into Power BI, select each column and set the display format of the columns to h:mm:ss.

Giving this 

Depending on what you are doing, this may or may not be the right approach.  You may need to convert these values to Duration data type, rather than Time.

Regards

Phil

Hi PhilipTreacy , 

Really appreciate your help ! You're such a kind person! Thank you!!!😀

Best regards,

Hi ntruong1994 

No worries.  If my answer solves your problem please mark it as the soluton so others will know what worked as it may help them in the future..

Regards

Phil