Formatting a Time Cell
Overview
By default, the time cell displays time values in either 12- or 24-hour format, as specified by the Windows regional settings. You can specify that the cell displays time values in either format, independent of the Windows settings.
The time cell also uses the Windows regional settings to determine what separator character to use between the hour, minute, and if displayed, seconds, portions of the time value. If you prefer, you can specify a different character to use as the separator.
By default, the time cell does not display the seconds portion of the time value, but it can do so if you prefer.
The following figure illustrates a time cell that displays time in the 24-hour time format with seconds and uses a custom separator character.