Archive for October 2019

unix time to spreadsheet time

In Unix and Linux, times are stored as seconds since the Unix Epoc, 1970-01-01 00:00:00. Spreadsheets often use a different Epoc and they tend to store days instead of seconds. When I import timestamped data that came from Unix land, I have to compensate for those differences. First, I format two cells to YYYY-MM-DD HH:MM:SS […]