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.