# Converting decimal degrees to degrees, minutes & seconds

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

1. ### SargeUSMC

Joined:
Apr 25, 2012
Messages:
8
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

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

Joined:
Jun 9, 2016
Messages:
32
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")&""""​