I’m dealing with the timestamps from Google form, which come in the following format.

Screenshot 2020-07-13 at 01.08.45.png

How do I separate the times and the dates? Whenever I try to do something with the values of the cells (e.g. using the functions LEFT, DATE, etc.), Excel tends to read the cells as general values, e.g. the cell A1 would have value “44024.99806”, and LEFT(A1) would give “4”. I’m using Excel Ver. 16.17 for Mac, if that helps.