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 |
1 Reply
Sort By
- Harun24HRBronze 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.