# NavList:

## A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding

Message:αβγ
Message:abc
 Add Images & Files Posting Code: Name: Email:
Re: Why 60 minutes in an hour and 24 hours in a day?
From: Frank Reed CT
Date: 2007 Mar 10, 20:02 EST
And tomorrow we have 23 hours in a day (Daylight Saving Time comes early starting this year in the USA).

"found while cruising through cyberspace looking for a means of
entering sexagesimal data into Excel cells. Does anybody know how to
do this ..?"

This is a recurring task. There are a number of solutions. The two solutions Nicolas mentioned are probably the most efficient. Another simple approach is to put degrees, minutes, and seconds in three cells, e.g. A1, B1, C1. Then in a fourth cell (which you can place off-screen, far to the right, so it doesn't get crowded), you can put the fomula =A1+B1/60+C1/3600. A fancier approach is to enter something like 120d 40' 12" (for 120 deg, 40min, 12 sec) in a single cell. Then in another cell, or more likely several cells, you parse this out as a string and then do the calculation (you'll learn more than you want to know about spreadsheet functions). It's a trade-off between appearances and ease of maintenance.

You might get some useful ideas on structuring navigation spreadsheets from Arthur Pearson's lunar distance calculation spreadsheet which you can find here:
This is one page in a web site which used to be "pointed to" by the URL "ld-DEADLINK-com". It hasn't been updated in years which makes it a sort of time capsule of the navigation list's consensus understanding of lunars from about four years ago --before I joined.

-FER
42.0N 87.7W, or 41.4N 72.1W.
www.HistoricalAtlas.com/lunars

AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com.

--~--~---------~--~----~------------~-------~--~----~
To post to this group, send email to NavList@fer3.com
To unsubscribe, send email to NavList-unsubscribe@fer3.com
-~----------~----~----~----~------~----~------~--~---

Browse Files

Drop Files

### Join NavList

 Name: (please, no nicknames or handles) Email:
 Do you want to receive all group messages by email? Yes No
You can also join by posting. Your first on-topic post automatically makes you a member.

### Posting Code

Enter the email address associated with your NavList messages. Your posting code will be emailed to you immediately.
 Email:

### Email Settings

 Posting Code:

### Custom Index

 Subject: Author: Start date: (yyyymm dd) End date: (yyyymm dd)