Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 .
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