Sum hours and minutes

[rosscortb]

Hello

I added a custom column to convert seconds to hrs and mins and then another column to round this to nearest half hour. How do I create a column or measure that will give me the total time in hours and mins please, since its a time value?

[V-lianl-msft]

Hi @rosscortb ,

Refer to this blog:

https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486 

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

[rosscortb]

@V-lianl-msft  Hello, Thanks for reply.  I added the Dax formula to a new column and it worked. However, it comes out as Text, therefore you can't add it to get total hours and mins, any ideas? Thanks Ross

[V-lianl-msft]

Hi @rosscortb ,

Refer to this thread:

https://community.powerbi.com/t5/Desktop/Seconds-to-Hours-Minutes-sum/m-p/888051 

This is the way to calculate the total.

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

[amitchandak]

@rosscortb , Try like

time(hour(round(hour([time]+minute([time])/60,second([time])/3600),0)),0,0)

You can use roundup or rounddown in place of round

[rosscortb]

sorry, is this done in power query?