Select the date and time cells (except header) and click Kutools > Text > Extract Text. And go to another column range and format it as time. Then in the Format Cells dialog, click Date under Categories section and select one date type. Select one column range and right click to select Format Cells from context menu. Firstly, you need to format cells as date and time.
Split timetag download#
With the convenient utility – Extract Text of Kutools for Excel, you also can quickly extract the date and time from one column to two columns.Īfter installing Kutools for Excel, please do as below: （Free Download Kutools for Excel Now!)ġ. However, the Remove time from date utility of Kutools for Excel can quickly remove timestamp permanently from the date time formatting in Excel.
In Excel, to remove 12:11:31 from 12:11:31 and make it exactly, you may have to take some time to create a formula to handle this job. The most easy and conveniet method to split date and time is applying the Split Cells utility of Kutools for Excel, no doubt! Kutools for Excel, with more thanģ00 handy functions, makes your jobs more easier.
Then the date and time have been split into two cells. Go to the first cell of Time column (except header) and type this formula =A2-C2 (A2 is the cell you split by, and C2 is the date cell), and drag fill handle over the range you need. Then in the first cell of the Date column (except the header), type this formula =INT(A2) (A2 is the cell you need to split by), then drag the fill handle to the range needed to apply this formula. Click OK to close the Format Cells dialog. Then go to select another column range you want to put the time only and format them as the time type you need. In the Format Cells dialog, under Number tab, click Date from Category section, the go to Type list to select a date type you need. Select a column range that you want to put the date results only, and right click to select Format Cells from the context menu. Here are some formulas can help you quickly split the date and time.ġ. If you use copy and paste functions to copy the each date and time one by one, it is time-waste. Split date and time by Kutools for Excel (3 steps with clicks)
0 kommentar(er)
