Welcome to the NavList Message Boards.

NavList:

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

Compose Your Message

Message:αβγ
Message:abc
Add Images & Files
    Name or NavList Code:
    Email:
       
    Reply
    Re: Excel for sight reductions
    From: David Pike
    Date: 2024 Oct 6, 13:56 -0700

    Phil N
    I didn't read your question properly.  Degrees and minutes to degrees.degrees is even simpler.  See below.  Hit 'enable editing' and press the desired cell to see the actual cell formulea.  Never mind; my first try will work for sextants reading in seconds of arc , and with a few string cells like 15'/min or 14.3'/min added can easily be converted for time to arc values for Moon, Aries, or Moon values for use with the nautical almanac.  DaveP

    File:
    Degrees-and-minutes-to-decimal-degrees.xlsx
       
    Reply
    Browse Files

    Drop Files

    NavList

    What is NavList?

    Get a NavList ID Code

    Name:
    (please, no nicknames or handles)
    Email:
    Do you want to receive all group messages by email?
    Yes No

    A NavList ID Code guarantees your identity in NavList posts and allows faster posting of messages.

    Retrieve a NavList ID Code

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

    Email Settings

    NavList ID Code:

    Custom Index

    Subject:
    Author:
    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