Separate date and time in a cell
Medica
-
PHILOU10120 Posted messages 6463 Registration date Status Contributor Last intervention -
PHILOU10120 Posted messages 6463 Registration date Status Contributor Last intervention -
Hello,
Hello and thank you for your help
In one column, there is a date and a time of connection to my application.
Can we separate these 2 pieces of information into 2 distinct columns or delete the time?
Here is what I have in the cell: 2017-03-02 14:27:37 +0100
I would like to keep only 2017-03-02
Thank you in advance
Configuration: Macintosh / Safari 10.0.3
Hello and thank you for your help
In one column, there is a date and a time of connection to my application.
Can we separate these 2 pieces of information into 2 distinct columns or delete the time?
Here is what I have in the cell: 2017-03-02 14:27:37 +0100
I would like to keep only 2017-03-02
Thank you in advance
Configuration: Macintosh / Safari 10.0.3
1 answer
-
Hello
In an adjacent cell, put this formula for the date
=LEFT(A1,10)*1
the cell must be in the date format dd/mm/yyyy
For the time
=LEFT(A1,19)*1-INT(LEFT(A1,19)*1)
the cell is in the format hh:mm:ss
It is by forging that one becomes a blacksmith. - It is at the foot of the wall that one sees the mason - one always learns from their mistakes
