6: Clarius Model 4200A-SCS Parameter Analyzer
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)
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(34619.976)
Returns
.
Returns 23.000E+0.
Returns the present hour of the present day.
Also see
DAY (on page 6-278)
MINUTE (on page 6-287)
MONTH (on page 6-288)
NOW (on page 6-289)
SECOND (on page 6-291)
YEAR (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)
The value to be returned if Condition evaluates to True
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