Forum Discussion
Sum Duration
Hi,
I wanna sum the duration of some activities.
I have a table with activities done by employee during a month.
I wanna make some analyze by activity and employee.
Please find below the database.
https://drive.google.com/drive/u/1/folders/1u-MMDymJQc9uXfpiRiMFfBPhOYQWMCcm
Anonymous , This example have pbix : https://forum.enterprisedna.co/t/time-format-3755-greater-than-24-hours/4733/5
The basic idea it split hr, min and sec add separately as three numbers and combine back
use
Mod for remainder
and quotient for quotient
5 Replies
Anonymous ,
refer if these can help
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
Hi amitchandak
Thanks for your promt respons.
I was trying to use the formula suggested on the links provided but the results are not ok.
I wanna have eg.:
Name Jan Feb Mar Total
Alin 08:30:00 08:00:00 52:00:00 68:30:00
Anonymous , This example have pbix : https://forum.enterprisedna.co/t/time-format-3755-greater-than-24-hours/4733/5
The basic idea it split hr, min and sec add separately as three numbers and combine back
use
Mod for remainder
and quotient for quotient