firmatting hours and minutes

[jgarciac]

Hello, please, your help

I have a data that indicates 200 hours, 31 minutes, 10 seconds in this way 200: 31: 10, if I formulate it in one hour, for cases greater than 24 hours it generates an error, and powerbi understands it as text, and I can not add the times, how can I solve it?

[v-yuta-msft · Accepted solution]

@jgarciac ,

Yes, power query generates an error because your time is not valid. As a workaround, you can split the time into three different columns [Hour], [Minute] and [Second] as below:

 

Community Support Team _ Jimmy Tao

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