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     www.energyefficientbuild.com.   Nov 13, 2013
question by superflycasanova (http://productforums.google.com/forum/?zx=3p34c7g6hlry#!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
40.921

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)?
-----------------------------------------------------------------------------------------------------------------------------