B2B Data Exchange
- B2B Data Exchange 10.4.0
- All Products
Symbol | Description |
---|---|
h | Display the hour as a number without a leading zero. |
[h] | Elapsed time, in hours. If you are working with a formula that returns a time where the number of hours exceeds 24, use a number format similar to [h]:mm:ss. |
hh | Display the hour as a number with a leading zero when appropriate. If the format contains AM or PM, then the hour is based on the 12-hour clock. Otherwise, the hour is based on the 24-hour clock. |
m | Display the minute as a number without a leading zero. |
[m] | Elapsed time, in minutes. If you are working with a formula that returns a time where the number of minutes exceeds 60, use a number format similar to [mm]:ss. |
mm | Display the minute as a number with a leading zero when appropriate. The m or mm must appear immediately after the h or hh symbol, or Excel displays the month rather than the minute. |
s | Display the second as a number without a leading zero. |
[s] | Elapsed time, in seconds. If you are working with a formula that returns a time where the number of seconds exceeds 60, use a number format similar to [ss]. |
ss | Display the second as a number with a leading zero when appropriate. If you want to display fractions of a second, use a number format similar to h:mm:ss.00. |
AM/PM am/pm A/P a/p | Display the hour using a 12-hour clock. Excel displays AM, am, A, or a for times from midnight until noon, and PM, pm, P, or p for times from noon until midnight. |