Splitting a Date with time (dd.mm.yyyy hh.mm.ss) into two spereate Columns

Hello,
I have a friend at work who merges Excel lists each week. She does it by hand, without the help of any formulas for macros, and I would like to help her a bit with the more tedious parts of it.
One of the most time-consuming parts for her is the splitting of a column called "scheduling."
The column contains a bunch of dates along with an exact time.

For Example:

26.01.2023 13:34:12
10.01.2023 12:31:35
09.01.2023 14:03:59
09.01.2023 13:33:01
26.01.2023 12:33:11
10.01.2023 10:37:52

The goal is to split this column into two different columns, "Date" and "Time."
I could not really make this work like I planned to. Sadly, after transferring the times, the next step would be to convert the times into time sections.
For example, the time 13:34:12 would turn into 12:00?18:00. 10:37:52 would need to become 07:00?12:00. Every time after 12:00 should be replaced with the first, and every time before 12:00 should be the second timeframe.

Is there a good way to do that easily? I experimented with formulas but couldn't get anything to work consistently.*
The idea is to have an Excel sheet with two sides. one where she can just paste all of the raw data, and the second one with the merged or split columns.

Maybe someone had a similar problem and can help me with it!

Scheduling.xlsx