LinkBack URL
About LinkBacks
I have attached a speadsheet showing what i need to convert. From Deg MM.ddd to Deg.dddd
Thank you for any help
I have attached a speadsheet showing what i need to convert. From Deg MM.ddd to Deg.dddd
Thank you for any help
Try =-1 ^ OR(RIGHT(B2)={"S","W"}) * LEFT(B2, FIND("°", B2)-1) + MID(B2, FIND("°", B2) + 1, FIND("'", B2) - FIND("°", B2) - 1)/60
Entia non sunt multiplicanda sine necessitate
Re: Coordinate Conversion
Worked great! thank youOriginally Posted by shg
I just took out the '-' for the longitude.
Oops, wrong formula:
=-1 ^ OR(RIGHT(B2)={"S","W"}) * (LEFT(B2, FIND("°",B2)-1) + MID(B2, FIND("°",B2)+1, FIND("'",B2) - FIND("°", B2) - 1)/60)
You don't need to change anything for longitude.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks