NavList:
A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding
Re: Why 60 minutes in an hour and 24 hours in a day?
From: Nicol�s de Hilster
Date: 2007 Mar 10, 10:12 +0100
From: Nicol�s de Hilster
Date: 2007 Mar 10, 10:12 +0100
Hi Peter, > From: > http://www.springfrog.com/converter/decimal-time.htm > very interesting stuff, the French have used the 10 hour system as well, many clocks still survive. > found while cruising through cyberspace looking for a means of > entering sexagesimal data into Excel cells. Does anybody know how to > do this ..? > > What I usually do when I need to enter data as 32�45'10" is simply enter the data as: "=32+45/60+10/3600" into a cell. I know it is not what you want it to be, but at least you can edit and change it. The other thing you can do is entering the data as time, so as "32:45:10". The only thing is that you will have to multiply the figures with 12 in order to use them in your calculations and you cannot edit them. So in cell A1 you put the figure 32:45:10 and when you need the sinus of it you say in cell B1 "=SIN(A1*12/180*PI())". Hope this helps Nicol�s --~--~---------~--~----~------------~-------~--~----~ To post to this group, send email to NavList@fer3.com To , send email to NavList-@fer3.com -~----------~----~----~----~------~----~------~--~---
