Calculating Dates from Non Leap Seconds

  • Thread starter Thread starter Mac Lingo
  • Start date Start date
M

Mac Lingo

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Elapsed GPS seconds between two struct tm times? 1
Calculating calendar days and completion dates. 4
Birthday calculations 10
Leap year date calculation 4
Calculating a Julian Date 7
Text to Date code needs refinement 4
calculate age from today's date (changes daily) and birthdate 4
Custom Document Properties - Last Calculation Date 2

Back
Top