Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

0
yogeshmaney

Time / Duration Format

Submitted by Helper I on ‎07-05-2022 06:14 AM

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

See more ideas labeled with:
2 Comments (2 New)
Comments
v-yingjl
Community Support
Community Support
‎07-05-2022 06:49 PM
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
Community Support
‎07-06-2022 11:39 PM
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

Idea Statuses