How do I represent values in Degrees Minutes Seconds in Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Topcon Ben - 04 Mar 2008 13:28 GMT

I need to format the results of a =DEGREES(ATAN(x)) formula to be in Degrees
Minutes Seconds format. I don't want to have to do decimal degrees, not put
the results in 3 different columns (which I have done in the past).

Reply to this Message

Gary''s Student - 04 Mar 2008 13:42 GMT

See:

http://support.microsoft.com/?kbid=213449

So if A1 contains:
0.2
and B1 contains:
=DEGREES(ATAN(A1)) (displaying 11.30993247)
then another cell containing:
=convert_degree(B1) will display 11° 18' 36"

Signature

Gary''s Student - gsnu200771

> I need to format the results of a =DEGREES(ATAN(x)) formula to be in Degrees
> Minutes Seconds format. I don't want to have to do decimal degrees, not put
> the results in 3 different columns (which I have done in the past).

Reply to this Message

Topcon Ben - 04 Mar 2008 13:56 GMT

Thanks for your help. That's awesome. What a time saver this will be.

> See:
>
[quoted text clipped - 10 lines]
> > Minutes Seconds format. I don't want to have to do decimal degrees, not put
> > the results in 3 different columns (which I have done in the past).

Reply to this Message