Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Convert milliseconds to date (in Excel)

ayi

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 addition row that will show it as date/time.

ayi_2

Converting your value in milliseconds to days is simply <code>(MsValue / 86,400,000)</code>
We can get 1/1/1970 as numeric value by DATE(1970,1,1)
<pre><code class="lang-auto">= (MsValueCellReference / 86400000) + DATE(1970,1,1)

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