Duration greater than 24 gives error

[danielmbaquero]

Good day people,

I have this column that indicates the amount of time an operation was in a department. This is a "duration" format. Nonetheless, power query recognized the column as text. And when I manually change the type to duration, those columns with times greater than 24 hours give an error.

Any help on this? 

[camargos88 · Accepted solution]

Hi @danielmbaquero ,

Try this m code to convert it:

[danielmbaquero]

@camargos88 that worked perfectly! Thank you!