Forum Discussion

尤聖文's avatar
尤聖文
New Member
2 years ago

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 ex...
Need Help
spinfuzer's avatar
spinfuzer
Solution Sage
2 years ago

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
尤聖文's avatar
尤聖文
New Member
2 years ago

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.