Convert Latitude Longitude in Excel

[rodwilma]

I have a spreadsheet with the following degrees,minute,seconds coordinates but I need to convert these to decimal degrees (all in the State of Florida). There are not dashes or periods in the format as seen below. Anyone know how?

Latitude DMS	Longitude DMS
28 25 18	-81 28 28
28 25 15	-81 27 35
28 25 15	-81 27 35
28 25 16	-81 26 33

<colgroup><col style="width: 82pt; mso-width-source: userset; mso-width-alt: 3986;" width="109"> <col style="width: 88pt; mso-width-source: userset; mso-width-alt: 4278;" width="117"> <tbody>
</tbody>

Input is greatly appreciated.

Thanks!

 

[West Man]

Try: =SUM(LEFT(A3,2),MID(A3,4,2)/60,RIGHT(A3,2)/3600)

Sorry, I did not notice your comment on the formatting, try: =SUM(LEFT(A3,2),MID(A3,3,2)/60,RIGHT(A3,2)/3600)

 

[rodwilma]

Thank you West Man!

It works on the latitude but something is off on the longitude. I placed the converted points on a map and they wind up in the ocean.

 

[West Man]

For longitude try: =SUM(LEFT(B3,3),-MID(B3,5,2)/60,-RIGHT(B3,2)/3600)

 

[rodwilma]

Thank you so much!! You are the best. I really appreciate this!

 

[securityman]

For longitude try: =SUM(LEFT(B3,3),-MID(B3,5,2)/60,-RIGHT(B3,2)/3600)

Shoudn't this be =SUM(LEFT(B3,3),-MID(B3,4,2)/60,-RIGHT(B3,2)/3600)[/QUOTE]

Also, can this be done in reverse. Take this and convert it to degrees, minutes, and seconds?

 

[rodwilma]

I took the first DMS lat/long listed above and placed these points in itouchmap.com. Itouchmap provided me with the decimal degrees which when using West Man's formulas matched exactly.