Need expression explained please

Hi Jtischler,

let
    DurationFromYourText = (text as text) as duration =>
        let
            Split = Text.Split(text, ":"), //splits the text duration field into a list for every ':' it finds
            AsNumbers = List.Transform(Split, Number.FromText), //sets the type for each item in the list to a number
            Duration = #duration(0, AsNumbers{0}, AsNumbers{1}, AsNumbers{2}) //creates an actual duration field from the items in the list. Assuming the field is hours, minutes, seconds. Power Query uses zero based index, so 0 is the first item, 1 the second etc.
        in
            Duration,
    Invoked = DurationFromYourText([UpTime]) //uses a column called 'UpTime' in the function to convert
in
    Invoked

What format is your text in for duration, not hours:minutes:seconds ?

Paste some example data.

You can just do this if you want 0.

Duration = #duration(0, AsNumbers{0}, AsNumbers{1}, 0) 

Glad I could help.

M is the language used in Power Query, DAX is everything to do with creating measures, calculated columns, tables.

If this is solved please accept solution on one of my answers above.