SOLVED

Covert Milliseconds to Date/Time in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2288998%22%20slang%3D%22en-US%22%3ECovert%20Milliseconds%20to%20Date%2FTime%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2288998%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20convert%20milliseconds%20(e.g.%26nbsp%3B1613808000000)%20to%20Date%2FTime%20format%3F%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2288998%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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.