Published August 3rd, 2011
If you have a CSV file containing timestamps as milliseconds then this formula will convert into Excel date time
Assuming your millisecond timestamp is in cell A1
=(A1/1000 + ("1/1/1970"-"1/1/1900"+1)*86400) / 86400 or if you have rows with missing timestamps:
=IF(A1="", "", (A1/1000 + ("1/1/1970"-"1/1/1900"+1)*86400) / 86400) If you are using UNIX timestamps which only have 1 second accuracy then change
A1/1000 + ... to
A1 + ... Adapted from a solution on http://www.mrexcel.com/forum/showthread.php?t=130691
Similar Articles STOP: 0xC0000221 Unknown Hard Error SystemRoot System32 ntdll.dll Microsoft Excel Yes/No drop box Microsoft Word cross reference clauses and update them in a contract [SOLVED] Excel 2010 very slow to open files Excel join columns together (string concatenation) Microsoft Excel Yes/No drop box [SOLVED] Excel 2010 very slow to open files Share this on your social networks!
| ||||||
All content on this website is Copyright 2003-2013 Chris Newland Privacy Policy
|
Leave comments, ask questions, or suggest improvements