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"

v	A	B
1	Column1.1	Column1.2
2	7/22/2017	11:30:00 AM
3	11/9/2018	7:00:00 PM
4	1/20/2019	1:30:00 PM