User Guide

Back Next

Time Formats

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.