Sep 06 2021 03:12 AM
11 July 2014 12:00:00 |
I have a column with data an time in the format above ,I am finding it difficult to split
I have tried INT fuction, text to colum function ,concatenate function still not getting the fix.
Please help
Sep 06 2021 03:43 AM - edited Sep 06 2021 03:50 AM
I guess it is with the format "dd mmmm yyyy hh:mm:ss"
You can either
Change the format of the cell (CTRL+1)
or
Use a formula to meet your needs (Considering A2 contains the date)
=TEXT(A2,"mm/dd/yyyy") Resulting in "09/06/2021"
=TEXT(A2,"h:mm:ss") 12:00:00
Remember that using formula you are converting the values to a text value.
So I would suggest you just make reference to the Date cell and apply the desired format.
Sep 06 2021 03:46 AM
Let's say you have such a date in A2.
To extract the date, enter the formula =INT(1*A2) in a cell and format that cell as a date.
To extract the time, enter the formula =MOD(1*A2,1) in a cell and format that cell as a time.
Alternatively, use =DATEVALUE(A2) and =TIMEVALUE(A2)
Sep 06 2021 04:21 AM
Sep 06 2021 04:40 AM
SolutionSep 06 2021 05:22 AM
Sep 06 2021 05:22 AM
Sep 06 2021 04:40 AM
Solution