Forum Discussion
swaroop710
Dec 17, 2020Copper Contributor
Convert Date & Time to milliseconds in Excel
I have date in A1 (6/11/2020) and time in B1 (7:49:47 AM). I am looking for a way to convert these to milliseconds. I tried =(A1-DATE(1970,1,1))*86400 to convert the date value in A1, but it seems ...
HansVogelaar
Dec 18, 2020MVP
Make sure that you format the cell with the formula as General.