Formulas for converting latitude and longitude in Excel.
To convert degree-minute-second format into decimal degrees:
decimal degrees= degrees+(minutes/60)+(seconds/3600)
To convert integer degrees-decimal minute format into decimal degrees:
decimal degrees= integer degree+(decimal minutes/60)
TopoFinder webpage for latitude and longitude conversion
http://nris.mt.gov/wis/location/LatLong.asp