Data Type - Duration

[crjackson]

Hello!

I am working on a dashboard to show staff's time accruals. The hour format is shown below. When I try to convert it to duration, it shows errors. The report comes in Hrs:Min:Sec. Please help!

[artemus]

The format for duration is Day.Hrs:Min:Sec where Day, Hrs,Min are integers, and Sec is a decimal.

Since Hrs is at or over 24 an error occurs, as that would be one day. Instead you will need to parse this manually using a function like:

(d as text) as duration => 
let 
   parts = List.Transform(Text.Split(d, ":"), Number.FromText),
   asDuration = #duration(Number.IntegerDivide(parts{0}, 24), Number.Mod(parts{0}, 24), parts{1}, parts{2})
in
   asDuration

[Peter_Beck]

Take a look at this problem, which may be the same as yours:

https://community.powerbi.com/t5/Power-Query/Duration-Conversion-and-Calculation/m-p/3132207#M100280

Basically, converting from a time or date won't work the way you want it to, so be sure that the data is not of that type. 

Hope this helps - 

Peter