Creating Time Cells
Overview
Time cells display time values. You can specify one of several time formats, as shown in the following figure.
You can set maximum and minimum values for the time values, and you can customize the available time formats. In addition, you can provide a spin button to let users quickly change time values.
For a description of how time cells validate data, see Data Validation.
In summary, you can use the following properties to customize time cells. The italicized properties are unique to this cell type. For more information on remembered properties, refer to Cell Type Settings Remembered.
| TypeEllipses | TypeTime24Hour | TypeTimeSeparator |
| TypeHAlign | TypeTimeMax | TypeVAlign |
| TypeSpin | TypeTimeMin | |
| TypeTextOrient | TypeTimeSeconds |