Converts a string with degrees, minutes, seconds to decimal degrees.
Syntax
DEGREE(String)
Input
String | a string with degrees, minutes, seconds as DDD°MM'SS" or DDD MM SS, optionally followed by N (North), S (South), E (East) or W (West) |
Domain: | system domain String |
Output
DEGREE returns: | is a value in degrees |
Domain type: | system domain Value |
Notes:
Tip:
When the definition symbol = is used, a dependent output column is created; when the assignment symbol := is used, the dependency link is immediately broken after the output column has been calculated.
Usable in
Examples
Pocket line calculator examples:
? DEGREE("7 30 18") | returns 7.5050 |
? DEGREE("7 30 18 S") | returns -7.5050 |
TabCalc example:
OutCol = DEGREE(InCol)
InCol |
OutCol |
25°00'00" |
25.000 |
-25°00'00" |
-25.000 |
45°00'00"N |
45.000 |
45°07'30"S |
45.125 |
45°15'00" |
45.250 |
45°30'00" |
45.500 |
45°45'00" |
45.750 |
See also:
DMS | LAT |
SEC | LON |