Format to Degrees, Minutes, Seconds

[SamMaynard]

Does anyone know how to convert or format a decimal to degrees, minutes and seconds?

Sam

 

[Smitty]

Hey Sam,

See: http://www.cpearson.com/excel/latlong.htm

HTH,

Smitty

 

[Seti]

If you are converting radian measures to degrees, the DEGREE function will get you degrees as a start.

 

[Greg Truby]

There's probably a better way, but I think I put this together right:

=TEXT(INT(A1),"0° ")&TEXT(INT((A1-INT(A1))*60),"0' ")&TEXT((A1*60-INT(A1*60))*60,"0.0")&""""

(Edit) This is a little easier to read on the end:
=TEXT(INT(A3),"0° ")&TEXT(INT((A3-INT(A3))*60),"0' ")&TEXT((A3*60-INT(A3*60))*60,"0.0")&CHAR(34)
(EndEdit)

 

[SamMaynard]

Greg,

Thanks so much. That was exactly what I needed. Thank you.

A big thank you for the others who responded so quickly.

Have a great day.

Sam

 

[Yogi Anand]

Hi Sam:

How about trying ....

=TEXT(MOD(A1,360)/24,"[hh] mm ss")&" in degrees minutes and seconds"

as illustrated in ...

Book1
	A	B	C	D
1	36.3	361800indegreesminutesandseconds
Sheet1

 

[Greg Truby]

Why do such elegant, simple solutions seem so ruddy obvious after someone else posts 'em. Very nice, Yogi.

 

[Yogi Anand]

Why do such elegant, simple solutions seem so ruddy obvious after someone else posts 'em. Very nice, Yogi.

Hi Greg:

I liked your solution too -- Very Nice!

 

[Double XL]

Use the following in a cell:
=[degrees] / 24

and format that cell:
[h]°mm'ss\"