HMS→ | ||
| 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 | |
| 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
Using mathematical functions |