Troubles getting duration for more than 24 hours power query

[Anonymous]

Hello! Im having an issue that I saw in another post people could solve it using a formula but I cant unfortunately (I'm using a formula @MFelix posted in another guys topic with the same issue)

I have this column with those values, and I want to get the same values but shown as a duration

If I use this formula (That is the one I saw it worked for other people)

let
    DurationFromYourText = (text as text) as duration => let
        Split = Text.Split(text, ":"),
        AsNumbers = List.Transform(Split, Number.FromText),
        Duration = #duration(0, AsNumbers{0}, AsNumbers{1}, AsNumbers{2})
    in
        Duration,
    Invoked = DurationFromYourText([UpTime])
in
    Invoked

 I get this error:

Could somebody please give me a hand?

Thank you very much!

[PaulMac]

@Daryl-Lynch-Bzy But how do I implement such answer as this into an existing query?

I just receive an error stating "Expression.Error: There is an unknown identifier. Did you use the [field] shorthand for a _[field] outside of an 'each' expression?"

Sigh 😥

[Daryl-Lynch-Bzy]

@PaulMac - can you please create a new issue to share with the community?

[Daryl-Lynch-Bzy · Accepted solution]

Hi  @Anonymous - this is problem with the Seconds in the duration function.

AsNumbers{0}, AsNumbers{1}, AsNumbers{2}

 Please remove the AsNumbers{2} by setting to 0.  or change to the following

AsNumbers{0}, AsNumbers{1}, try AsNumbers{2} otherwise 0

Many thanks

Daryl

[Anonymous]

Thank you so so much!!! When you told my I realize how silly my error was.

Thank you!