DMS to Decimal Degree

[MJL5043]

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

 

[Rick Rothstein]

This formula should preserve the full decimal accuracy of your original cell values (I am not 100% sure that shg's formula does that)...

=SIGN(A1)*(INT(ABS(A1)/10000)+INT(MOD(ABS(A1),10000)/100)/60+MOD(ABS(A1),100)/3600)