View original (French)

Separate Date and Time from a Single Cell

Lorenzo59 -  
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   -
Hello,

After searching, I couldn't find an answer to my problem.
Your help would be valuable to me.
Following a file import, I find myself with the date and time in the same cell.
I want to use these data separately.
How can I separate these two data into different columns?
Thank you in advance for your assistance.

2 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    your data in A1
    in B1 the formula:
    =INT(A1) will give you the date with the cell formatted as a date
    and in C1:
    =A1-B1 will give you the time in hh:mm:ss format
    or to get the time directly:
    =A1-INT(A1)
    best regards

    --
    The quality of the answer mainly depends on the clarity of the question, thank you!
    1