Time / Duration Format

[yogeshmaney]

Hello, 

I see Time / Duration in hh:nn:ss instead of hh:mm:ss (snapshot attached). Is there any particular reason, I may be wrong.

Regards,

Yogesh Maney

[v-yingjl]

Have submited this issue internal to confirm(ICM: 318761837), would update here as soon as possible if there is any progress about it.

Best Regards,
Community Support Team _ Yingjie Li

[v-yingjl]

This is by design. Power BI supports custom format strings and has inbuilt default formats but it uses the VBA format string pattern. 

Here is the VBA documentation: https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/format-function-v...

Here is the Power BI Documentation: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

In VBA format, the minutes representation is with "n" and thus that is what we show in the formats. If the user is specifying a custom format by themselves, they would need to use "n" for minutes and not "m"

Best Regards,
Community Support Team _ Yingjie Li