Results 1 to 8 of 8

Format to Degrees, Minutes, Seconds

This is a discussion on Format to Degrees, Minutes, Seconds within the Excel Questions forums, part of the Question Forums category; Does anyone know how to convert or format a decimal to degrees, minutes and seconds? Sam...

  1. #1
    Board Regular
    Join Date
    Dec 2002
    Posts
    106

    Default Format to Degrees, Minutes, Seconds

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

    Sam

  2. #2
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Crested Butte, CO
    Posts
    27,245

    Default Re: Format to Degrees, Minutes, Seconds

    Hey Sam,

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

    HTH,

    Smitty

  3. #3
    Board Regular
    Join Date
    May 2002
    Location
    CT
    Posts
    2,915

    Default 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. #4
    MrExcel MVP
    Int'l Moderator
    Greg Truby's Avatar
    Join Date
    Jun 2002
    Location
    39 17' 15" N, -94 40' 26" W
    Posts
    9,770

    Default 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)
    Greg

    Work: XL 2003, 2007 and 2010 on Windows 7
    Please use CODE tags - especially for longer excerpts of code.

  5. #5
    Board Regular
    Join Date
    Dec 2002
    Posts
    106

    Default 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. #6
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454

    Default Re: Format to Degrees, Minutes, Seconds

    Hi Sam:

    How about trying ....

    =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
    =

    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.
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  7. #7
    MrExcel MVP
    Int'l Moderator
    Greg Truby's Avatar
    Join Date
    Jun 2002
    Location
    39 17' 15" N, -94 40' 26" W
    Posts
    9,770

    Default Re: Format to Degrees, Minutes, Seconds

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

    Work: XL 2003, 2007 and 2010 on Windows 7
    Please use CODE tags - especially for longer excerpts of code.

  8. #8
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454

    Default Re: Format to Degrees, Minutes, Seconds

    Quote 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!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com