Split the Time Using Power Query or Get & Transform
One of the interesting features of Power Query or Get & Transform is that it will help you to Split your time into Hours, minutes and seconds so that you can process it easily.
You can also browse our Power Query Tutorial Catalog here.
NOTE 1: You can create random excel workbook online here for practice purposes as I did in this tutorial.
NOTE 2: If You use Microsoft Excel Prior to 2016 Version, then You Need to download Power Query Separately.
Previously In Power Query: How to Format Text Using Power Query?
STEP1. Firstly, select your data and press the shortcut Ctrl + T or by going to Insert > Table then it will turn into Excel Table.
STEP2. Now in the second step follow this procedure:
For Excel 2016:Go to Data > Get & Transform > From Table
For Excel 2013 & 2010: Power Query > Excel Data > From Table
STEP3. Now the Power Query Editor is open up so now get the hour, minute and second.
Select the Order Time Column and,
Go to Add Column > From Date & Time > Time> Hour > Hour
Now select the Order Time Column again and follow this:
Go to Add Column > From Date & Time > Time> Minute
Ensure to select Order Time Column and follow:
Go to Add Column > From Date & Time > Time> Second
STEP4. Now open a brand new worksheet with all the updated records in your excel by clicking the Close & Load from your Home tab.
Here is your times split with Hour, Minute and Second.