Wednesday, November 13, 2013

yogi_ Convert Longitude In Degrees And Minutes To Degrees and Thousandths Of Degrees

                                          Google Spreadsheet   Post  #1419
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Nov 13, 2013
question by superflycasanova (!category-topic/docs/spreadsheets/wDa38owgrAE)
converting a degree and minute longitude to a decimal degree longitude
I've got a list of longitudes that look like this in a spreadsheet
40°55.26 N
and I want to convert them to decimals

Is there a way of automating this procedure e.g. take the numbers before the ° add the decimal point and then add the numbers after the °/60 (and get rid of the N)?