Dec 17 2020 03:56 PM
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 to show
#VALUE! |
The format for A1 is 'date' and B1 is 'custom'
Any suggestion is appreciated.
Date | START TIME | END TIME |
6/11/2020 | 7:49:47 | 7:51:17 |
Dec 18 2020 12:08 AM
Make sure that you format the cell with the formula as General.
Dec 19 2020 03:07 AM
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.
May 27 2021 12:10 PM
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