decimalLatitude = IF(NS = "S",(DEGREE + MINUTES/60 + SECONDS/3600)*-1, (DEGREE + MINUTES/60 + SECONDS/3600)) decimalLongitude = IF(EW = "W",(DEGREE + MINUTES/60 + SECONDS/3600)*-1,(DEGREE + MINUTES/60 + SECONDS/3600))