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

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 >

(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 >

1. Calculating number of days between two dates that fall between two other dates

2. Calculate number of non-weekend days between two dates?

3. AP340 LEAP and non-leap users

4. Calculate expirate date taking into account leap year

5. Calculate by Date (non date fields)

6. Calculating dates based on two dates from 24 hours

7. Calculating the difference between two dates if two criteria are m

8. How do I calculate the midpoint date between two dates.

9. Calculating the number of dates within two specific dates.

10. Calculating the difference between two dates if two criteria a

11. Trigger - Calculate date based on two other dates

12. Calculate the difference betwen two columns -two dates

13. calculate between two days if the second date is blank.

14. About calculate months between two date (date function)

15. Calculating number of days between two dates that fall between two

2 post • Page:**1** of **1**