Time Codes (Predefined)

Use any of the following numeric time codes to format a time as shown. If you require a custom format, you can build one using the text codes shown in Time Formatting Codes.

Time Code

Example

Description

0

 

no time

1

103211

HourMinuteSecond

2

10:32:11

hour:minute:seconds

3

10321100

HourMinuteSecondHundredth

4

10:32:11:00

hour:minute:seconds:hundredths

5

10:32

hour:minute

6

10:32:11 AM

hour:minute:seconds AM or PM

7

10:32 AM

hour:minute AM or PM

8

103211000

hour minute second thousandths

9

10:32:11.000

hour:minute:second.thousandths

Time Formatting Codes - Used to display a time value.

Time- Function that uses the codes listed above.