Welcome to the NavList Message Boards.


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

Compose Your Message

Add Images & Files
    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).
    Peter, you asked:
    "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.
    42.0N 87.7W, or 41.4N 72.1W.

    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


    What is NavList?

    Join NavList

    (please, no nicknames or handles)
    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 Settings

    Posting Code:

    Custom Index

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

    Visit this site
    Visit this site
    Visit this site
    Visit this site
    Visit this site
    Visit this site