Posts Tagged ‘time’
Today, I had the problem of converting a timestamp to a readable time format inside excel. Not quite as easy as I would have hoped for, but the solution is fairly painless.
In the excel column you wish to display the date, you need to place the following formula.
=(((COLUMN_ID_HERE/60)/60)/24)+DATE(1970,1,1)
You would then need to replace COLUMN_ID_HERE with the cell that holds the timestamp. e.g. A1
The above formula can be simplified, but I think the above explains a little more what is actually being done to the data 
You would then need to format the cell to be dd/mm/yyyy hh:mm and you are done
So, its only a few hours away from the timestamp 1234567890 and we just went past 1234543210. As always, sad enough to take a photo (well, Jordan (www.oxcreative.com) took the photo) on a monitor in our office which is displaying www.coolepochcountdown.com. Its only 6 or so hours till all hell breaks out and the time starts going backwards (or we just see a nice timestamp come and go).
