Forum Discussion

mdlarosa1's avatar
mdlarosa1
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

1 Reply

  • Harun24HR's avatar
    Harun24HR
    Bronze 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.

Resources