View Single Post
 
Old 06-17-2013, 10:11 PM
fzuazua fzuazua is offline Windows XP Office 2003
Novice
 
Join Date: Jun 2013
Posts: 2
fzuazua is on a distinguished road
Default Decimal degrees to Deg Min Sec

If cell “E19” is 78.359272 in degrees decimal then:
CONCATENATE(TEXT(INT(E19),"##° "),TEXT(INT((E19-INT(E19))*60),"##'"),TEXT(MOD((E19-INT(E19))*60,INT((E19-INT(E19))*60))*60,"##.##"),"""")
Will return:
78° 21' 33.38"
It may seem complicated but it give the exact format to put in to Google Earth or similar software. U can do all your calculations in decimal. If u use radians u must convert to degrees before applying the formula.