Worksheet Date & Time – How to Split it?
In worksheet type this function to get Time enter the formula ‘=Now()’ .
It will return the default value as today’s date & time in the cell. Something like this.
You can see that there is a Date part & Time part.
Split Date & Time Part in Excel
Assume you have entered the above formula in cell A1.
Now, You can retrieve only the date part to cell A2 & Time part to cell A3, using this formula.
Type these formula & press enter. You will get value as ’05/07/2018′ & ’13:53′
There are other ways too, which can split date & time. But this is the easiest way. You can also use Data Text To Columns options as well.