NavList:
A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding
Re: Excel for sight reductions
From: Peter Hakel
Date: 2024 Oct 6, 08:06 -0700
From: Peter Hakel
Date: 2024 Oct 6, 08:06 -0700
You can enter 12° 34.5’ as a formula =12+34.5/60 or format cells as mixed numbers e.g., 12 345/600 (see attached screenshot). You can also enter degrees and decimal minutes in separate cells and combine them later via that formula.
Peter Hakel
https://navigationspreadsheets.wordpress.com
File:
