Convert Text (x Hours, xMinutes, xSeconds) to duration

[Brazen_BI]

Attempted unsuccessfully to convert text from column labeled "Handled Duration" into duration type with format "00:00:00". Purpose is to eventually use this column to calcuate total and average handle time durations. Have tried simply changing format (which returns expressions:error:we couldn't parse the Duration literal). I'm aware of the duration.fromtext function, though every iteration i've tried has failed. Can someone please assist?

[slorin · Accepted solution]

Hi, @Brazen_BI 

=Time.From(
   Text.Combine(
       List.Transform(
              Text.Split([Handled Duration],", "),
              each Text.BeforeDelimiter(_," ")),
       ":")
)

or

#time(
   Number.From(Text.BeforeDelimiter([Handled Duration]," Hours")),
   Number.From(Text.BetweenDelimiters([Handled Duration],"Hours, "," Min")),
   Number.From(Text.BetweenDelimiters([Handled Duration],"Minutes, "," Sec")))

Stéphane 

[Brazen_BI]

Thanks. I combined this solution with a measure to calculate average duration time to get the final visual I needed: 

Average Handle Time Duration = FORMAT(AVERAGE('Table'[Column]),"HH:MM: SS")