Note that this doesn't actually separate the date and time. It will
display only date or time, but calculations based on B2 & C2 will use
the combined date-time.

From your description, that may be acceptable.

In article ,
Gary''s Student wrote:

If your value is in A2 and it is a "true" date/time, then in B2 enter:
=A2 and format the cell as a date
and in C2 enter
=A2 and format the cell as a time.