Link Search Menu Expand Document

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