split date and time into two cells

[aaaaa34]

Hey my friends,
In cel A1, there is date and time together.
I need a formula to split them into following columns as it is shown in attached file.
Pls check the link: https://jumpshare.com/v/sSGwGXDJPfVWcl4UwBcf (Click "Download" button in up-right part of the page)
Waiting for your help.
Thank you.

 

[Rick Rothstein]

You can use =INT(A1) for the date and =MOD(A1,1) for the time (but you will probably have to format the cells to display these values in the way that you want).

 

[aaaaa34]

=INT(A1) for the date and =MOD(A1,1) for the time

Yes, after I formatted C1 and D1, it carried out. Thank you, Mr. Rothstein.

 

[alansidman]

Alternative solution: Split the column using Power Query. One step and then export back to Excel.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Split Column by Delimiter" = Table.SplitColumn(Table.TransformColumnTypes(Source, {{"Column1", type text}}, "en-US"), "Column1", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, false), {"Column1.1", "Column1.2"})
in
    #"Split Column by Delimiter"

[table="class:thin_grid"]
[tr][td]v[/td]
[td="bgcolor:#ECF0F0, align:center"]A[/td]
[td="bgcolor:#ECF0F0, align:center"]B[/td]
[/tr][tr][td="bgcolor:#ECF0F0, align:center"]1[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Column1.1[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]Column1.2[/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]2[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]7/22/2017[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]11:30:00 AM[/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]3[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]11/9/2018[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]7:00:00 PM[/td]
[/tr]
[tr][td="bgcolor:#ECF0F0, align:center"]4[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]1/20/2019[/td]
[td="bgcolor:#FFFFFF, align:CENTER"]1:30:00 PM[/td]
[/tr]
[/table]