Forum Discussion

Copper Contributor

Jun 20, 2025

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

Bronze Contributor

Jun 21, 2025

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.