Sum duration?

Question

Hello,I have a Excel:&nbsp;I want to Sum those durations in Power BI. It should return Hours and Minutes like 12:35h. How can I realize this? What format should I use in Excel? I managed to sum those durations up with a measure but it returns a text value, so it is impossible to make eg. a bar chart. The measure is:&nbsp;Zeitaufwand=VAR&nbsp;TotalSeconds=SUMX('Zeitaufwand Bewirtungen',HOUR('Zeitaufwand Bewirtungen'[Zeitaufwand Delegation/Gruppen])*3600+MINUTE('Zeitaufwand Bewirtungen'[Zeitaufwand Delegation/Gruppen])*60+SECOND('Zeitaufwand Bewirtungen'[Zeitaufwand Delegation/Gruppen]))VAR&nbsp;Days&nbsp;=TRUNC(TotalSeconds/3600/24)VAR&nbsp;Hors&nbsp;=&nbsp;TRUNC((TotalSeconds-Days*3600*24)/3600)VAR&nbsp;Mins&nbsp;=TRUNC(MOD(TotalSeconds,3600)/60)VAR&nbsp;Secs&nbsp;=&nbsp;MOD(TotalSeconds,60)return&nbsp;IF(DAYS=0,"",IF(DAYS&gt;1,DAYS&amp;"days ",Days&amp;"day"))&amp;IF(Hors&lt;10,"0"&amp;Hors,Hors)&amp;":"&amp;IF(Mins&lt;10,"0"&amp;Mins,Mins)&amp;":"&amp;IF(Secs&lt;10,"0"&amp;Secs,Secs)

amitchandak · Answer

Anonymous , There are couple of blogs around that, see if those can help
&nbsp;
Durationhttps://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-daxhttps://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx

anonymous · Answer

They did not help.

v-janeyg-msft · Answer

Hi,&nbsp;Anonymous&nbsp;
&nbsp;
You say you want to return the hour and minute, but the measure contains day, hour, minute, and second.&nbsp;This seems a bit contradictory, and the information you share is not enough for us to modify.

So can you share some insensitive data samples and your expected output? Then may be we can think of a workaround for you.
&nbsp;
Best Regards,Community Support Team _ Janey

Forum Discussion

Sum duration?

3 Replies

Related content

Sum Of Duration

sum of time duration

notebook duration time issue

Sum of Duration

Sum Duration