Convert milliseconds to date (in Excel)

Convert milliseconds to date (in Excel)

Asked on January 11, 2019 in Excel.
Add Comment


  • 2 Answer(s)

    Try this best solution :

        This (MsValue / 86,400,000) is used to Converting the value in milliseconds to days 

    By using DATE(1970,1,1)  to get 1/1/1970 as a numeric value. 

    = (MsValueCellReference / 86400000) + DATE(1970,1,1)
    

        To get date and time of 19/04/2010 08:16:11 by using the value of 1271664970687 and converting it as dd/mm/yyyy hh:mm:ss 

    Answered on January 11, 2019.
    Add Comment

    Use the following link to convert milliseconds to date (in Excel)

    Converting unix timestamp to excel date-time forum thread.

    Answered on January 11, 2019.
    Add Comment


  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.