Date Time

[mnhhs]

Hi, I'm trying to split the given date format "2/09/2019  8:42:00 AM" into columns

"2/09/2019"

"8:42:43 AM"

Can someone pls assist with the formula, thanks

[meeravijayan2011 · Accepted solution]

Split the date-time into columns using Text to Columns tool by setting the delimiter as \s (Space). 

Hope the attached workflow will help you.