Hi all, a new comer here, thanks for looking I hope the thread title is understandable but I'll explain  I have lots of data to convert and I'm using excel. The raw data came in an individual cell  41° 35.87' I was reading on other threads to convert with degrees, minutes and seconds, but I need degrees and decimal minutes I guess. I'm assuming the developer tool in excel will be needed as the data is one cell but I don't know what to program to write to convert all the cells into just degree decimal such as  41.598 Thanks for looking and thanks in advance for any help that can be offered.
Announcement
Collapse
No announcement yet.
Unconfigured Ad Widget
Collapse
convert degree decimal minutes to decimal degrees in excel
Collapse
X

Re: convert degree decimal minutes to decimal degrees in excel
Thank you so much for the formula, it works a treat. I am now however met by another problem. My data came in Northings and then Eastings and Westings. I should have explained this in my first post but I didn't see it as a problem then. The data switches from West to East in the middle of the range of data and hence Excel cannot turn the positive West into negative East. Advice from anyone here would be of benefit. Kind regards,
Comment

Re: convert degree decimal minutes to decimal degrees in excel
Hi, I am having trouble understanding the solution that was just posted. I input the formula to compute the data but did not attain the correct answers as I would achieve if I was using a calculator. I have attached a sample of the data below so maybe it could help to portray what I am trying to do. Thanks in advance and I appreciate all input. Thanks againAttached Files
Comment

Re: convert degree decimal minutes to decimal degrees in excel
Hi all, a new comer here, I need ur help, really2 need. I have lots of data to convert and I'm using excel, I'm tired if i must convert it one by one with google earth .. need time too much to do it
The raw data came in an individual cell > 7 22.042 and 108 12.867
I was reading on other threads to convert with degrees, minutes and seconds, but I need degrees and decimal minutes I guess. I'm assuming the developer tool in excel will be needed as the data is one cell but I don't know what to program to write to convert all the cells into just degree decimal such as > 7.367367 and 108.214450
Thanks for looking and thanks in advance for any help that can be offered.
Comment
Trending
Collapse
There are no results that meet this criteria.
Comment