Forum Discussion
Duration Format [hh]:mm
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
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.
2 Replies
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
JimmyCheck 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.
