excel

Converting Excel Dates to UNIX Timestamps

Dec 7, 2011 microsoft excel

A previous article showed how to convert a UNIX Timestamp to an Excel Date. It’s also possible to do the reverse- convert an Excel Date value to a UNIX formatted Timestamp.

Converting UNIX Timestamps to Excel Dates

Oct 10, 2011 microsoft excel

Faced with analysing a proprietary log file from a Linux system I turned to Excel to look at the data. The dates in this log file were stored in the standard UNIX timestamp format (number of seconds since midnight on the 1st January 1970) so I needed a formula to convert this into something readable. This is what I …

Outputting CSV from an ASP page

Mar 16, 2011 microsoft visualbasic vb.net excel asp.net

I’ve recently had the need to write an ASP page which reads a SQL database and outputs into Microsoft Excel- a user clicks on a link to this ASP page and Excel opens up with a new spreadsheet of the data. This is how I did it

Clean Hard Drive

Apr 29, 2008 microsoft excel mysql visualbasic vb.net

Some work I’ve been involved with (see here and here) with UNIX Timestamps threw up another challenge today- getting the timestamp for midnight on January 1st of the current year. This is what I came up with: