History CSV format
- Thread starter Dale Ward
- Start date
Bryan Mayland
TVWBB Hall of Fame
The first column is the standard UNIX timestamp, seconds since midnight January 1st 1970 UTC.
I googled and found:
http://www.berezniker.com/content/pages/office/excel-convert-unix-time-excel-time
Unix time is the number of seconds since January 1, 1970.
Excel doesn't contain built-in functions for working with Unix dates so they must be derived.
Excel allows you to add a number of days to a date by using the "+" operator. Let's make use of that.
First convert the number of seconds to number of days (by dividing by 60*60*24) and then add the result to the date "1/1/1970".
The formula will look like
=CELL/(60*60*24)+"1/1/1970"
The quotes around the date are required. If they are not present, Excel will treat 1/1/1970 as an expression.
http://www.berezniker.com/content/pages/office/excel-convert-unix-time-excel-time
Unix time is the number of seconds since January 1, 1970.
Excel doesn't contain built-in functions for working with Unix dates so they must be derived.
Excel allows you to add a number of days to a date by using the "+" operator. Let's make use of that.
First convert the number of seconds to number of days (by dividing by 60*60*24) and then add the result to the date "1/1/1970".
The formula will look like
=CELL/(60*60*24)+"1/1/1970"
The quotes around the date are required. If they are not present, Excel will treat 1/1/1970 as an expression.