Extract Date/Time to Date and Time

[ernestgoh]

Hi have this simple problem but I do not know the solution.

In Cell A1 = 01/12/2008 12:00:00 AM

I am trying to extract in cell A2 = 01/12/2008 and A3 = 12:00:00 AM.

But I will end up having a string of numbers each time I try to right (A1,11).

My end result is I will use the values in A3 if between 12am to 5am, assign a value in A4 as "Night Shift"

A1 = 01/12/2008 12:00:00AM
A2 = 01/12/2008
A3 = 12:00:00Am
A4 = if(And(A3>12,A3<5),"Night Shift","Day Shift")

Thanks in advance for helping!