excel
Convert Excel serial number date to VFP date
By Sergey - Posted on January 1st, 2008
Excel stores dates as the number of days since 1900-01-00. The number 1 represents 1900-01-01 and so on. The time part, if present, is represented as decimal portion. There's a bug in implementation of that sequence. It assumes that there was 1900-02-29 but 1900 is not a leap year. As result the code below correctly convert dates starting with 1900-03-01 only.
For more info about Excel dates see How to use dates and times in Excel and Dates And Times In Excel.
Excel - Convert Unix Time to Excel Time
By Vadim - Posted on December 2nd, 2007
If you ever find yourself needing to convert from UNIX time in Excel, here's the solution.
Recent comments
2 weeks 4 days ago
2 weeks 5 days ago
2 weeks 5 days ago
5 weeks 5 days ago
10 weeks 3 days ago
10 weeks 3 days ago
11 weeks 1 day ago
12 weeks 18 hours ago
13 weeks 3 days ago
13 weeks 3 days ago