Time calculations

[Guest]

Your formula for caluculating time since 1/1/1900 is incorrect. It includes
a leap year for the year 1900. However, there was no leap year that year
because it is not divisable by 400. The year 1900 is important in SNTP
applications.
Thanks,
Paul Nichols
802-877-4288
(e-mail address removed)

 

[garfield-n-odie]

This is a known issue that dates back to the beginning of Excel
and Lotus 123. See http://support.microsoft.com/kb/214326/en-us
"Excel 2000 incorrectly assumes that the year 1900 is a leap year".