How to write 30.89 degree in degree minute and second. I did not understand the above format.

Hi,

Please, get back to the thread below. Paul has thoroughly elaborated regarding this issue.


https://www.msofficeforums.com/excel...html#post34536



Best

Jamal

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.

Thanks fzuazua. Sounds to be cool. I’ll be trying it and see if it works with me

Best

Jamal

Hi fzuazua,

The code is working fine but sounds that it is for displaying purposes only. No calculations can be made!

So, for example, if the angles are required to be summed, then this operation can’t be performed

Is there still a way to have the correct display while the operations can also be preformed

Other relevant threads are

From decimal to degree
https://www.msofficeforums.com/excel...html#post50083


Angles calculations
https://www.msofficeforums.com/excel...lculation.html


Best

Jamal

Attached Images

	Clip_444.jpg (72.2 KB, 81 views)
	Clip_445.jpg (61.7 KB, 77 views)

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############## ##################"),"""")