Converting decimal degrees to degrees, minutes & seconds

[SargeUSMC]

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!

 

[XLPadawan]

Sarge,
Give this a try (at the very least it will give you the necessary calculations):

 

[XLPadawan]

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")&""""​