cancel
Showing results for 
Search instead for 
Did you mean: 
0

Time / Duration Format

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

 

PowerBI HHMMSS_Screenshot 2022-07-05 183457.jpg

Status: Delivered

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

Comments
v-yingjl
Community Support
Status changed to: Accepted

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
Community Support
Status changed to: Delivered

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