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 ...
It looks like your date and time are kept as texts (left aligned), of so simply applying of another format won't help, you need to convert texts to actual date/time (aka numbers). Better to have small sample file to be sure.