Model 4200A-SCS Parameter Analyzer Reference Manual
Section 6: Clarius
4200A-901-01 Rev. C / February 2017
6-291
SECOND Calc worksheet function
This command returns the seconds component of the supplied date/time serial number
Usage
SECOND(
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
Extracts seconds from the serial number created by the
NOW
function.
Example
=SECOND(0.259)
=SECOND(34657.904)
=SECOND(NOW())
Returns
58.0000E+0
.
Returns
46.0000E+0
.
Returns the present second of the present minute.
Also see
(on page 6-278)
(on page 6-280)
(on page 6-287)
(on page 6-289)
(on page 6-296)
SIGN Calc worksheet function
This command determines the sign of a specified number.
Usage
SIGN(
Value
)
Value
Any number
Details
SIGN
returns 1 if the specified number is positive. It returns
−
1 if the specified number is negative.
Example
=SIGN(-456)
=SIGN(456)
Returns
-1.0000E+0
.
Returns
1.0000E+0
.
Also see
(on page 6-273)
