Sum of duration over 24 hours

[SAMBWILLANS]

Hi There

im recording course times in PowerBi as time  (hh:mm:ss) however we have a number of course that are now over 24 hours.

I had the following in to calculate a sum which worked fine once all courses were under 24 hours but now we have additonal data this is throwing out the sum.

sum of duration =

VAR _sum=sum(Dashboard_All_Course_Completion[Duration (HH:MM) for Reporting])*86400

VAR _h=int(_sum/3600)

VAR _m=int((_sum-_h*3600)/60)

VAR _s=int(_sum-_h*3600-_m*60)

return _h

Any ideas how I can tackle this?

Many Thanks in advance for the help!!!!

Sam 

[daXtreme]

There is a special data type dedicated to this kind of calculations. It's called Duration. Both, in Power Query and in DAX.

[SAMBWILLANS]

I've tried changing the data type but this just errors out. Any additional suggestions?