Formats for dates and times

Days, months, and years To display days, months, and years, include the following format codes in a section. If you use "m" immediately after the "h" or "hh" format code or immediately before the "ss" or "s" code, Microsoft Graph displays minutes instead of the month.

To display

Use this format code

Months as 1–12

m

Months as 01–12

mm

Months as Jan–Dec

mmm

Months as January–December

mmmm

Months as the first letter of the month

mmmmm

Days as 1–31

d

Days as 01–31

dd

Days as Sun–Sat

ddd

Days as Sunday–Saturday

dddd

Years as 00–99

yy

Years as 1900–9999

yyyy


Hours, minutes, and seconds To display hours, minutes, and seconds, include the following format codes in a section.

To display

Use this format code

Hours as 0–23

h

Hours as 00–23

hh

Minutes as 0–59

m

Minutes as 00–59

mm

Seconds as 0–59

s

Seconds as 00–59

ss

Hours as 4 AM

h AM/PM

Time as 4:36 pm

h:mm am/pm

Time as 4:36:03 p

h:mm:ss a/p

Elapsed time in hours; for example, 25:02

[h]:mm

Elapsed time in minutes; for example, 63:46

[m]:ss

Elapsed time in seconds

[ss]

Fractions of a second

h:mm:ss.00


Note: If the format contains an AM or PM, the hour is based on the 12-hour clock, where "AM," "am," "A," or "a" indicates times after midnight to 12:00 noon, and "PM," "pm," "P," or "p" indicates times after noon to 12:00 midnight. Otherwise, the hour is based on the 24-hour clock. The "m" or "mm" must appear immediately after the "h" or "hh" format code or immediately before the "ss" code, or Graph displays the month instead of the minutes.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×