• Enter our Anniversary Prize Drawing for a chance to win a 70th Anniversary Weber Limited-Edition Kettle Grill! Click here to enter!

History CSV format


Dale Ward

What it the format for column "A "?
If A is the time how to get it to display something that relates to the time of day?

D Peart

I googled and found:


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


The quotes around the date are required. If they are not present, Excel will treat 1/1/1970 as an expression.