Custom Time Format

After selecting Custom from the time format list, click browse. The Time Format window is displayed.

You can only use non-alphanumeric characters as separators, excluding the {, } and [, ] non-alphanumeric characters, in the Time Format window.

The following table provides time format examples.

Time Format Description Example
HH24 2-digit hour in 24 hour format (00-23) 23
H24 1- or 2-digit hour in 24 hour format (0-23) 11
HH12 2-digit hour in 12 hour format (00-12) 08
H12 1- or 2-digit hour in 12 hour format (0-12) 8
MM 2-digit minute (00-59) 09
M 1- or 2-digit minute (0-59) 9
SS 2-digit second (00-59) 05
S 1- or 2-digit second (0-59) 5
AM/PM Meridian (AM/PM) AM
ZZZ A time zone abbreviation. See "Time Zones" for a list of supported time zones. EST
+/-ZZZZ Hours and minutes before or after the Greenwich Mean Time (GMT). GMT is now referred to as Coordinated Universal Time (UTC). +0500
+/-ZZ:ZZ 4-digit time where the format is a 2-digit hour and 2-digit minute, separated by a colon. +05:00
+/-ZZ[:ZZ] 4-digit time where the format is a 2-digit hour and an optional 2-digit minute, separated by colon. +05:00
+/-ZZ[ZZ] 4-digit time where the format is a 2-digit hour and an optional 2-digit minute. +0500
TZD 4-digit time where the format is a 2-digit hour and 2-digit minute, separated by a colon. Z on output, if value is +/-00:00. +05:00

After you define and save a custom format, the custom format string is displayed in the Properties window. For example, the custom date format CCYYMMDD, and the custom time format HH24MMSS display as:

{CCYYMMDD}{HH24MMSS}


Feedback