Forum Discussion
Solved
Convert the column into duration - Throwing an error
Hi I have the below column I am trying to convert it into duration. Getting below error message Expression.Error: We couldn't parse the Duration literal. Details: 24:18:34 I c...
If you're going to use the Custom #duration( ) function then no need for the if else:
try
let _arr = List.Transform(Text.Split([Duration],":"),each Number.FromText(_)) in
#duration (
0 , _arr{0} , _arr{1} , _arr{2}
)
otherwise null
That's a good pick up AllisonKennedy