Quote:
Originally Posted by fzuazua
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.
|
First off Sorry for dragging up an old subject but google seemed to think it was relevant.
Thanks that sort of got me there it is a bit broken from when there was just seconds or parts of Seconds.
=CONCATENATE(TEXT(INT(E19),"00° "),TEXT(INT((E19-INT(E19))*60),"00' "),TEXT(MOD((E19*60*60),"1"),"00.000############## ##################"),"""")
07-09-2018, 05:44 PM
Similar Threads
Excel 2007 cell format help!!!
Windows 7 64bit 
Office 2016
Hybrid Mode