About this tutorial:
Video duration: 00:03:16
If you download data into Excel, one column might have the Date and Time combined in each cell.
In this short video you will see how to quickly split that value into separate date and time columns.
The first method uses a simple formula, and the second method is done without a formula — just a bit of typing.
Visit my website to get the sample Excel workbook.
0:11 Split Date With Formulas
0:48 Get Time With Formula
1:30 Split Date Without Formulas
2:20 Get Time Without Formula
2:52 Get the Sample…