Separate Date and Time from a Single Cell
Lorenzo59
-
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributeur 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.
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 réponses
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!
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!