SOLVED

Covert Milliseconds to Date/Time in excel

New Contributor

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

Thanks in advance

2 Replies
best response confirmed by BMur2025 (New Contributor)
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.

 

S0345.png

Perfect, thank you.