NavList:

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.