Forum Discussion
Covert Milliseconds to Date/Time in excel
How do I convert milliseconds (e.g. 1613808000000) to Date/Time format?
Thanks in advance
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.
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.
- Perfect, thank you.
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!
