Sum of reporting duration - Colum data type time

[SAMBWILLANS]

Hi There

Please could I get some assistance with calculating a measure to sum a reporting duration

This is currently in BI as a time data type

how can i get a simple total sum? to display on a card?

Thank you!

Sam

[SAMBWILLANS]

Just a Total In Hours and Minutes ideally 🙂

[ryan_mayu · Accepted solution]

@SAMBWILLANS 

do you want to display days or only hours minutes and seconds?

pls try this(no days)

measure = 
VAR _sum=sum('Table (2)'[Duration])*86400
VAR _h=int(_sum/3600)
VAR _m=int((_sum-_h*3600)/60)
VAR _s=int(_sum-_h*3600-_m*60)
return _h&"h:"&_m&"m:"&_s&"s"

[Anonymous]

Create a new column for time either in hr or mm as per your need then just sum the value in the new column and you will get your answer