NavList:
A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding
Re: Why do we still use this terrible Babylonian hexadecimal system
From: Chuck Taylor
Date: 2004 Nov 18, 08:19 -0800
From: Chuck Taylor
Date: 2004 Nov 18, 08:19 -0800
--- Michael Dorl wrote:
> Is there anyway to use excel with dd mm ss data?
>
> I've been using the following macros to convert back
> and forth. ...
A simpler way is to use separate columns for dd, mm,
and ss, and then add a 4th column for Degrees. For
example:
A B C D
1 DD MM SS Degrees
2 25 12 30 =A2+B2/60+C2/3600
3 25 12 30 25.20833
4 43 18.2 43.30333
To use it, simply enter the formula in D2, then
replicate it downwards. Line 3 shows the result for
one example.
The same spreadsheet will work for DD MM.T, as shown
in line 4.
Chuck Taylor
47d 55' N
122d 11' W
__________________________________
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com
