Forum Discussion
Solved
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.