Calculating Dates from Non Leap Seconds

Calculating Dates from Non Leap Seconds

Post by Mac Ling » Tue, 20 Sep 2005 08:11:33


Hi,

From an application I am converting (Palm Pilot Todo Lists) I have dates in
"Non Leap Seconds" and I need to turn them into dates usable with my Excel
spreadsheets.

Goggeling hasn't brought up any useful algorithms. Does anyone out there
know any algorithm sources I could use to do this conversion?

Many thanks,
Mac Lingo
Berkeley, CA
 
 
 

Calculating Dates from Non Leap Seconds

Post by Myrna Lars » Tue, 20 Sep 2005 11:02:24

In Excel dates are stored as the number of days since Dec 31, 1899, with 1900
(erroneously) treated as a leap year.

Let's say the Palm Pilot system is the one that expresses a date as the number
of seconds since Jan 1, 1970, 0:00, and you have that number in A1. You
convert seconds to days by dividing by 86,400 (the number or seconds in a
day), then add Excel's number for the date Jan 1, 1970.

So the formula is

=A1/86400+DATE(1970,1,1)


On Sun, 18 Sep 2005 23:11:33 GMT, "Mac Lingo" < XXXX@XXXXX.COM >