Excel: DMS to Decimal Degree


I have read several posts on here relating to this topic but for some reason I have been unable to get the formulas provided in the other posts to work for the particular format I am working with. I guess I am just mentally seized up today. I apologize for having to repost a topic that has already been gone over several time. The format I am working with is 41°14'36" -76°51'46" and I need to have it report in 41.24326 -76.86277 The Lat will always be positive and the Long will always be negative. I would like to have this done in a single cell and not split up over 3. Thanks


This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of December 16, 2014.


For more resources for Microsoft Excel