SSpread.TypeTime24Hour Property
In the time cell, set the time display format.
Only valid for cells with the CellType property set to $CellTypeTime . Before setting this property, use the Col , Row properties, and so on to specify what to do.
Specify the following values. The initial value is the OS setting value.
| Constant | Value | Example ( 23:00 ) |
|---|---|---|
| $TypeTime24Hour12HourClock | 0 | 11:00 pm |
| $TypeTime24Hour24HourClock | 1 | 23:00 |
| $TypeTime12HourClockAm | 2 | 11:00 pm |
| $TypeTime12AmHourClock | 3 | 11:00 pm |
Set the TypeTimeSeconds property to $TRUE to display “seconds” .
This property is subject to property inheritance for time cells .
Use case
Col = 3;
Row = 2;
CellType = $CellTypeTime;
TypeTime24Hour = $TypeTime24Hour12HourClock;
Value = str(sysdate(), "HHMISS");
BlockMode = $TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypeTime;
TypeTime24Hour = $TypeTime12AmHourClock;
Value = str(sysdate(), "HHMISS");
BlockMode = $FALSE;
Related item
CellType , TypeTimeSeconds properties