Consider you have a date timestamp value in cell A1
A1 = 01/21/2022 11:35 PM
You want to extract date and time into two separate cells
Extract date
First change the cell type to Date ( Home->Format->Format Cells->Date)
Use this below formula.
= INT(A1)
Extract time
First Change the cell type to Date ( Home->Format->Format Cells->Time)
Use this below formula.
= MOD(A1,1)