Converting decimal degrees to degrees, minutes & seconds

Discussion in 'Excel' started by SargeUSMC, Apr 16, 2015.

  1. SargeUSMC

    SargeUSMC

    Joined:
    Apr 25, 2012
    Messages:
    8
    Likes Received:
    1
    I have a formula here that I found surfing for a solution:

    =IF(A2<0,"-"&TEXT(ABS(A2)/24,"[hh]\°mm\'ss\"""),TEXT(A2/24,"[hh]\°mm\'ss\"""))

    Given that cell A2 is the source data in decimal format

    I need to take "SS" out to 2 decimal places.

    Can this formula be manipulated to do that? If so, any help towards that end would be appreciated, as I don't know how to do it.

    Thanks.

    Semper Fi!
     
    SargeUSMC, Apr 16, 2015
    #1
    1. Advertisements

  2. SargeUSMC

    XLPadawan

    Joined:
    Jun 9, 2016
    Messages:
    32
    Likes Received:
    5
    Location:
    Allen, TX
    Sarge,
    Give this a try (at the very least it will give you the necessary calculations):

    upload_2016-6-14_20-0-35.png upload_2016-6-14_19-57-42.png
     
    XLPadawan, Jun 15, 2016
    #2
    1. Advertisements

  3. SargeUSMC

    XLPadawan

    Joined:
    Jun 9, 2016
    Messages:
    32
    Likes Received:
    5
    Location:
    Allen, TX
    Better yet, just paste this formula into any cell other than A2 (because that's where your input number is) in the same worksheet:
    =INT(IF(A2>0,A2,360-A2))&"°"&INT((IF(A2>0,A2,360-A2)-INT(IF(A2>0,A2,360-A2)))*60)&"'"&TEXT(((L5*60)-INT(L5*60))*60,"0.00")&""""​
     
    XLPadawan, Jun 15, 2016
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Mike Burnett
    Replies:
    0
    Views:
    656
    Mike Burnett
    Jan 7, 2016
Loading...