Forum Discussion

danielmbaquero's avatar
danielmbaquero
Regular Visitor
6 years ago
Solved

Duration greater than 24 gives error

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?