Separating Time and Date in Cells.

[ensbana]

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

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.

https://www.excelforum.com/editpost.php?p=5363893&do=editpost

 

[mrshl9898]

B1 =INT(A1)
C1 =A1-B1

Then format as date and time