Tag Archives: Timestamp

Converting UNIX Timestamps to Excel Dates

Unix Timestamps in ExcelFaced 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