Duration Format [hh]:mm

[Sandro_HE]

Hello Everyone

I have a file where we write down service durations we process for each customer. My goal is to sum up all durations for each customer and visualize these service durations with the format [hh]:mm. Works fine if I try this with Pivot, can't get it to work in Power Query / Power BI.

Example:

Customer	Service Time
A	80:20
B	71:45
C	53:30
D	20:24
E	05:59

Right now it shows these values in decimals, like this:

Customer	Service Time
A	3.35
B	2.99
C	2.23
D	0.85
E	0.25

Maybe someone has aaaa solution for this case?

Regards

Sandro

[Greg_Deckler · Accepted solution]

@Sandro_HE 

Check out Duration to Seconds: https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279#M92

and 

Chelsie Eiden's Duration here - https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

Converts to seconds, aggregates, allows you to display as duration while maintaining an underlying numeric value.

[Jimmy801]

Hello @Sandro_HE 

in Power BI is no possibility to sum durations. What you can do is to transform them to seconds in power query and create a measure in Power BI that sums the seconds and transforms them into a [h]:mm-format.

Read this for more help link 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy