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.

‘5/7/2018 13:53’

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.

A2: ‘=TEXT(A1,”mm/dd/yyyy”)’

A3: ‘=TEXT(A1,”hh:mm”)’

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.

Leave a Reply