Time Formatting Codes

All examples display 9:07:12 p.m.

String Example Description
h 9 Hours with no leading zero for single-digit hours. 12-hour clock.
hh 09 Hours with leading zero for single-digit hours. 12-hour clock.
H 21 Hours with no leading zero for single-digit hours. 24-hour clock.
HH 21 Hours with leading zero for single-digit hours. 24-hour clock.
m 7 Minutes with no leading zero for single-digit minutes.
mm 07 Minutes with leading zero for single-digit minutes.
s 12 Seconds with no leading zero for single-digit seconds.
ss 12 Seconds with leading zero for single-digit seconds.
f .1 Tenths of a second
ff .01 Hundredths of a second
fff .001 Milliseconds
t P One character time-marker string, such as A or P.
tt PM Multi-character time-marker string, such as AM or PM.

Example:

Time(now(1), "hh.mm.ss tt")

... displays: 09.07.12 PM

Time Codes (Predefined) - Used to display a time value.

Time - Function that uses the codes listed above.