Please help!
On an Excel 2007 spreadsheet I have one column for longitude and one for latitude in DDMMSS.s format (decimal minute degree).
I need to convert these cells into DD (decimal degree) format.
The mathematical formula is DD=D+M/60+S/3600, which for my case might look like DD+MM/60+SS.s/3600 if each digit is indicated.
What formula can I use to apply this conversion to each column rather than each individual cell, which would take countless hours (2000+ entries)?
Bookmarks