How to Sum time spent in power bi

[lennox25]

Currently my table is summing the total time spent as 600 minutes. I want to be able to show this total in hours and minutes. Can anyone help me? It should be 10 hours.

[Anonymous · Accepted solution]

Hi @lennox25 ,

lbendlin , thanks for your concern about this case. I tried to create a sample data myself based on the user's requirement and implemented the result. Please check if there is anything that can be improved. Here is my solution: 

You can create the following measure.

TotalTime = 
VAR TotalMinutes = SUM('Table'[Time])
VAR Hours = QUOTIENT(TotalMinutes, 60)
VAR Minutes = MOD(TotalMinutes, 60)
VAR Total = FORMAT(Hours, "0") & " Hours " & FORMAT(Minutes, "00") & " Minutes"
RETURN
    IF(ISINSCOPE('Table'[Date]), SUM('Table'[Time]),Total)

The final result is shown below.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[lennox25]

@Anonymous  Genius! Thank you works perfectly! 🙂

[lbendlin]

What should the result look like if it is over 24 hours?