What do I need to do to get Excel to recognize the following as a date (i.e. number of days since Jan 1, 1900), so I can do calculations (shift from UTC to PDT, delta t between measurements, etc)?
9/3/2019 3:33:00 PM
I tried simply setting the format to Date and then tried =DATEVALUE(F2), but still get #VALUE! as the output.
Thanks in advance if you think you might know the answer!
Have you tried this?
Thanks for your suggestion, but that didn't work for me.