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?
[TABLE="width: 170"]
<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>[TR]
[TD="class: xl49085, width: 109, bgcolor: silver"]Latitude DMS[/TD]
[TD="class: xl49085, width: 117, bgcolor: silver"]Longitude DMS[/TD]
[/TR]
[TR]
[TD="class: xl49086, bgcolor: transparent"]28 25 18[/TD]
[TD="class: xl49086, bgcolor: transparent"]-81 28 28[/TD]
[/TR]
[TR]
[TD="class: xl49086, bgcolor: transparent"]28 25 15[/TD]
[TD="class: xl49086, bgcolor: transparent"]-81 27 35[/TD]
[/TR]
[TR]
[TD="class: xl49086, bgcolor: transparent"]28 25 15[/TD]
[TD="class: xl49086, bgcolor: transparent"]-81 27 35[/TD]
[/TR]
[TR]
[TD="class: xl49086, bgcolor: transparent"]28 25 16[/TD]
[TD="class: xl49086, bgcolor: transparent"]-81 26 33[/TD]
[/TR]
</tbody>[/TABLE]

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.