Converts a string with degrees, minutes, seconds to seconds, i.e. Seconds=3600*DDD+60*MM+SS.
Syntax
SEC(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
SEC 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:
? SEC("7 30 18") | returns 27018 (= 3600 * 7 + 30 * 60 + 18) |
? SEC("7 30 18 S") | returns -27018 |
TabCalc example:
OutCol = SEC(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:
DEGREE | LAT |
DMS | LON |