Convert miliseconds to date (in Excel)

Question

I have a row in excel with the following data: 1271664970687 (I think it's the number of milliseconds from 1970...). I would like to have adition row that will show it as date/time.

Answer 1

See Converting unix timestamp to excel date-time forum thread.

Answer 2

Converting your value in milliseconds to days is simply (MsValue / 86,400,000)

Excel gives me that 1/1/1970 has the numeric value 25569, so your formula is:

= (MsValueCellReference / 86400000) + 25569

Using your value of 1271664970687 and formatting it as dd/mm/yyyy hh:mm:ss gives me a date and time of 19/04/2010 08:16:11

Neil.