Convert text field h:mm:ss to duration type in powerquery

[dpombal]

I have an excel with fields in this format and changing to duration type fails in powerquery

I need duration to sum column in DAX

0:13:53

0:13:53

0:53:34

0:31:32

0:47:33

1:05:25

0:52:10

[v-yuezhe-msft]

@dpombal,

I am able to directly change the data type of the text column to Duration or add a custom column.

=Duration.FromText([Column1])

Regards,
Lydia