calculate from degrees to degrees/minutes/seconds on excel?

C

C. Hollinger

I am a geomatics student and while using Microsoft Excel I find that there is
no method to automatically change from degrees to degrees/minutes/seconds.
If there is an add-in could you please tell me where it is?

thanks
 
B

Beege

You could use this, if decimal degrees are in A1
=A1*.0416666666667
then format cell/custom [H]° mm"m" ss "s"
The degree symbol is Alt-248

Keep in mind that Excel performs Trig functions on Radians, so conversion is
necessary

Beege
 

Ask a Question

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting Decimal Degrees to Degrees/Minutes/Seconds 1
Sexagesimal degrees calculations 0
How do I represent values in Degrees Minutes Seconds in Excel? 2
Access 2007,reports,VBA 2
how can I compute from degrees to degrees-minutes-seconds? 1
how do i use symbol of degree in excell work sheet using key board 2
Degrees Minutes Seconds 1
Gas Temperature correction factors in an excel spreadsheet. 10

Top