Spread 8.0 Documentation
Formatting a Time Cell
Support Options
User's Guide > Setting Up the Control > Setting the Cell Type > Creating Time Cells > Formatting a Time Cell

Glossary Item Box

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.

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.