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: Continue reading
This 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.
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 came up with. Continue reading
Often when writing a long document or report there is a need to switch from portrait (vertical) to landscape (horizontal) orientation for an individual page, for example to include a full-page table that is wider than it is high. This short “How To” explains how to do this using Microsoft Word 2003. Continue reading