Format to Degrees, Minutes, Seconds

Thanks:  0
Likes:  0

# Thread: Format to Degrees, Minutes, Seconds

1. ## Format to Degrees, Minutes, Seconds

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

Sam

2. ## Re: Format to Degrees, Minutes, Seconds

Hey Sam,

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

HTH,

Smitty

3. ## Re: Format to Degrees, Minutes, Seconds

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

4. ## Re: Format to Degrees, Minutes, Seconds

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)

5. ## Re: Format to Degrees, Minutes, Seconds

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

6. ## Re: Format to Degrees, Minutes, Seconds

Hi Sam:

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

as illustrated in ...

******** ******************** ************************************************************************>
 Microsoft Excel - Book1 ___Running: xl97 : OS = Windows 98
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
 B1 =

A
B
C
D
1
36.336 18 00 in degrees minutes and seconds
 Sheet1

[HtmlMaker 2.20] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

7. ## Re: Format to Degrees, Minutes, Seconds

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

8. ## Re: Format to Degrees, Minutes, Seconds

Originally Posted by Greg Truby
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!

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•