Forum Discussion
mdlarosa1
Jun 20, 2025Copper Contributor
how do I create formula in excel
I need to separate date and time into 2 columns 6/2/2025, 7:26 AM one column for date and one for time
Harun24HR
Jun 21, 2025Bronze Contributor
If your data is true date time value then use the following formula to separate date-
=INT(A2)And this is to separate time-
=MOD(A2,1)If your data is just string then could try [Date]-
=--TEXTBEFORE(A2,",")[Time]
=--TEXTAFTER(A2,", ")You must format resulting cells as proper date time formatting. See the attached file.