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 excel   ... pass 

used on query ...show  error

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

I can not to calculate sum .

 

Need Help

3 Replies

  • 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.