Date formatted as text

[mneuner]

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!

[#2]

@mneuner 

Have you tried this?

=INT(F2)

[#3]

@Subodh_Tiwari_sktneer 

Thanks for your suggestion, but that didn't work for me.