Convert 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.

HELP!

Thanks.

Semper Fi!

 

[eibi]

Welcome to the forums, Sarge!

Try this:

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

You may want to run some test numbers on it. I don't have any means of checking the validity of the results...

All best.