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)
RE: Duration Display [h]:mm:ss
Hola, como solucionar el problema planteado?
RE: Duration Display [h]:mm:ss
Completely agree.
See https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8814178-field-of-duration-type