Section 6: Clarius
Model 4200A-SCS Parameter Analyzer Reference Manual
6-280
4200A-901-01 Rev. C / February 2017
HOUR Calc worksheet function
This command returns the hour component of the supplied date and time serial number, specified in 24-hour
format.
Usage
HOUR(
Serial_number
)
Serial_number
The time as a serial number; the decimal portion of the number represents time as a
fraction of the day
Details
The result is an integer ranging from 0 (12:00 AM) to 23 (11:00 PM).
Needed to extract the hour from the serial number created by the
NOW
function.
Example
=HOUR(34259.4)
=HOUR(34619.976)
=HOUR(NOW())
Returns
9.000E+0
.
Returns
23.000E+0
.
Returns the present hour of the present day.
Also see
(on page 6-278)
(on page 6-287)
(on page 6-289)
(on page 6-291)
(on page 6-296)
IF Calc worksheet function
This command tests the condition and returns the specified value.
Usage
IF(
Condition
,
True_number
,
False_number
)
Condition
Any logical expression
True_number
The value to be returned if
Condition
evaluates to True
False_number
The value to be returned if
Condition
evaluates to False
Example
=IF(A1>10, "Greater", "Less")
Returns
Greater
if the content of
A1
is greater
than 10 and
Less
if the content of
A1
is less
than 10.
Also see
None