How to convert Unix Epoch time to date in Excel

If you have number of milliseconds since Unix epoch, for example 1724117711296, you can use the following Excel formula to convert it to date and time:

=(A1/86400000)+25569

Leave a Reply

Your email address will not be published. Required fields are marked *