Skip to main content
Microsoft Idea

Power BI

Needs Votes

Duration Display [h]:mm:ss

Vote (22) Share
's profile image

on 20 Jan 2018 05:35:25

I need to be able to display the duration of movement throughout stations. StationOne 12 hours and 30 minutes, StationTwo 16 hours and 15 minutes, StationThree 7 hours and 0 minutes. This is a total of 35 hours and 45 minutes. Some items take much shorter times, and need to be displayed down to the seconds level. In Excel, I do this by using the Custom time format [h]:mm:ss which displays my answer as 35:45:00. Trying to do the same thing in PowerBI displays 11:00:00, since it can only read as a date-time format and so rolls over at 24:00:00. This seems like a very basic functionality that I cannot believe is missing from such a powerful tool.

Comments (2)
's profile image Profile Picture

Angelica Maldonado on 06 Jul 2020 00:17:34

RE: Duration Display [h]:mm:ss

Hola, como solucionar el problema planteado?

's profile image Profile Picture

Chris99 on 05 Jul 2020 23:12:08

RE: Duration Display [h]:mm:ss

Completely agree.

See https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8814178-field-of-duration-type