converting survey angles to decimals

D

Duddly Dummy

I need to convert from 50d35'25" (survey instrument notation of an angle) to
the decimal equivalent of 50.59027778. Is there a function that will
automatically convert this? If not, any suggestions of a formula?
 
T

Teethless mama

Try this:

=VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C1,"d",":"),"'",":"),"""",""))*24

format cells as General
 

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

Imputting an angle degree. Degree, minute, second 1
how to convert from ° ' " to decimal ° 6
surveying formula 7
Draw two lines at given angles 0
Converting GPS coordinates to decimal in Report 0
Help with formula (decimal to fraction) 2
Help with formula 3
HOW DO I CONVERT ANGLES TO DECIMAL DEGREES 1

Top