Forum Discussion

swaroop710's avatar
swaroop710
Copper Contributor
Dec 17, 2020

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 ...

Resources