Convert Text to Time Values with Power Query (Data Cleansing Part 3)

This is the third video in a series of solutions for our Data Cleansing Challenge. In this video I explain how to use Power Query to convert the time stored as text into numeric time values in Excel.
Download the Excel file to follow along:

Read the full article:

In a previous video ( I shared this challenge to convert time/duration stored as text into time values that can be used for calculations and analytics.

Thanks to everyone that commented on the video and blog post with solutions. In this video we look at a solution posted by Walt.

The solution uses Power Query to extract/split the time components (hours, minutes, seconds into separate columns. We then merge the columns and convert the data type to a duration.

Checkout these articles if you are new to Power Query:

Power Query Overview: An Introductions to Excel's Most Powerful Data Tool (

The Complete Guide to Installing Power Query (



Here are links to the other solution videos:

Part 1 using Text Formulas:

Part 2 using SUMPRODUCT:

In the next video we look at how to use VBA UDF's (User Defined Functions) to solve the challenge (video coming soon).

excel,excel campus,text to time in excel,convert text to time,excel text to time conversion,excel text to time format,convert text to time in excel,how to convert time in text format to time format in excel,excel data cleansing techniques,excel data cleaning,excel data cleansing challenge,power query excel,power query tutorial,power query excel 2016,power query convert text to date,power query convert text to time,