• 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

TVWBB Fan
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

TVWBB Pro
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.
 

 

Top