Filter
Top Products
10-16 Using mathematical functions
HMS→ Hours-minutes-seconds to decimal. Converts a number or
expression in H.MMSSs format (time or angle that can include
fractions of a second) to x.x format (number of hours or
degrees with a decimal fraction).
HMS→(H.MMSSs)
Example
HMS→(8.30) returns 8.5
→HMS Decimal to hours-minutes-seconds. Converts a number or
expression in x.x format (number of hours or degrees with a
decimal fraction) to H.MMSSs format (time or angle up to
fractions of a second).
→HMS(x.x)
Example
→HMS(8.5) returns 8.3
INT Integer part.
INT(value)
Example
INT(23.2) returns 23
MANT Mantissa (significant digits) of value.
MANT(value)
Example
MANT(21.2E34) returns 2.12
MAX Maximum. The greater of two values.
MAX(value1,value2)
Example
MAX(210,25) returns 210
MIN Minimum. The lesser of two values.
MIN(value1,value2)
Example
MIN(210,25) returns 25