Help me to edit data text

[尤聖文]

I want to calculate sum of duration time (over 24 hours) , and I select data text (text to time)  . The result is error , because over 24 hours  format ex: 157:24:30 .  
 I used function value on excel   ... pass 

used on query ...show  error

or use function  value.from.text  ....show error and afternoon . 

I can not to calculate sum .

[spinfuzer]

Add custom column

let
    split = Text.Split([Column1],":"),
    value = Number.From(split{0})/24 + Number.From(split{1})/(24*60) + Number.From(split{2})/(24*60*60),
    total_dur = [ days = Number.IntegerDivide(value,1), hhmmss = Time.From(Number.Mod(value,1)) ] 
in
    total_dur

[尤聖文]

Thanks for your help.

I use function Table.splite : add three columns (hh,mm,ss) and select data (text to Integer ).

I look at your way.

[尤聖文]

additional ： use power bi to transfer data text