How to sum time in hours and minutes

[KJH]

Hi,

Trying to sum total time of in hours and minutes and seconds. I have converted the time to decimal format and tried the DAX code below though it is not giving me the correct number of days before I then divide to only show hours,mins & secs.

Can anyone assist me with where i am going wrong?

Thanks

KJH

[Anonymous · Accepted solution]

Hi, @KJH

I think it's possible to create a Table based on the Total Hours in your image.

Then create a Calculate Column to represent the value of Show in hours and minutes.

Total Sum of Hours =
     FORMAT(INT(20102.25),"00") & "h," & FORMAT(MOD(20102.25,1)* 60, "00") & "m"

Finally, convert it to Card form.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[KJH]

Hi, sorry, i could not get the above to work. I am looking to have the card showing the total time in hours and minutes.

This is not allowing me to upload a sample xlxs or power BI file.

KJH

[ryan_mayu]

@KJH 

maybe you can try something like below

Column = 
VAR d=int('Table'[hour]/24)
VAR h=int('Table'[hour]-d*24)
VAR m=int(('Table'[hour]-int('Table'[hour]))*60)
VAR s=('Table'[hour]-int('Table'[hour]))*60-int(('Table'[hour]-int('Table'[hour]))*60)
return d&"d"&","&h&"h"&","&m&","&s&"s"

if it's still not working, pls provide the sample data and expected output.