Forum Discussion
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 ...
Hi ,
Looks like you are selecting the wrong cell for the formulae:
Try Changing it to A2, and also for milliseconds you need to multiply to 86400000
so formulae looks something like this:
(A2-DATE(1970,1,1))*86400000