Covert Milliseconds to Date/Time in excel

[BMur2025]

How do I convert milliseconds (e.g. 1613808000000) to Date/Time format?

Thanks in advance

[#2 · Accepted solution]

@BMur2025 

Is this a Unix timestamp? If so, with such a value in A1, enter the following formula in B1:

=A1/86400000+25569

and format B1 as a date+time.

 

[#3]

Perfect, thank you.

[#4]

@Hans Vogelaar 

Thank you for posting this! I kept getting an error... it looks like I lost a couple decimal places somewhere along the line. It's working, it's working!