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.

Split the Time Using Power Query

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

Split the Time Using Power Query

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

Split the Time Using Power Query

Now select the Order Time Column again and follow this:

Go to Add Column > From Date & Time > Time> Minute

Split the Time Using Power Query

Ensure to select Order Time Column and follow:

Go to Add Column > From Date & Time > Time> Second

Split the Time Using Power Query

STEP4. Now open a brand new worksheet with all the updated records in your excel by clicking the Close & Load from your Home tab.

Split the Time Using Power Query

Here is your times split with Hour, Minute and Second.

Split the Time Using Power Query