Degrees Minutes Seconds conversion

[Joe]

Is there a function to convert decimal degrees to degrees
minutes seconds and back.

 

[Norman Harker]

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.

 

[Guest]

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.


.

 

[Norman Harker]

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.