Degrees Minutes Seconds conversion

  • Thread starter Thread starter Joe
  • Start date Start date
Hi Joe!

XL2000: Function to Convert Degrees/Minutes/Seconds Angles to or from
Decimal Angles:
http://support.microsoft.com/default.aspx?scid=kb;en-us;213449

Custom Function to Express Degree to/from as Fractions of Degrees:
http://support.microsoft.com/default.aspx?scid=kb;en-us;121944

Sounds like just what you want.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thanks Norman that is exactly what I needed.
-----Original Message-----
Hi Joe!

XL2000: Function to Convert Degrees/Minutes/Seconds Angles to or from
Decimal Angles:
http://support.microsoft.com/default.aspx?scid=kb;en- us;213449

Custom Function to Express Degree to/from as Fractions of Degrees:
us;121944

Sounds like just what you want.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.


.
Click to expand...
 
Hi Joe!

A rare event for Excel KBs <vbg>

But I omitted the best source of help:

Chip Pearson:
http://www.cpearson.com/excel/latlong.htm


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top