how to sum duration？

[hongyuliu]

I calculated the duration, then how to sum it,  get total working hour?  what data type the Duration column should be? thank you

[v-yiruan-msft]

Hi @hongyuliu ,

What's the format of the duration column? like hh.ms or hh:mm:ss? If the format is first one, then the data type of the duration column should be Decimal number. Otherwise, it should be Text type. You can refer the following documentions to get the sum of duration:

Power BI DATEDIFF only working days, hours and so on…

Sum a Duration

Duration Troubles

Best Regards

Rena

[amitchandak]

@hongyuliu , check if this can help

https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageK...

https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-i...