Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

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: https://www.excelcampus.com/powerquery/convert-text-to-time-values-power-query/

In a previous video (https://youtu.be/uhzLYTupl9I) 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 (https://www.excelcampus.com/powerquery/power-query-overview/)

The Complete Guide to Installing Power Query (https://www.excelcampus.com/tables/excel-tables-tutorial-video/)



Here are links to the other solution videos:

Part 1 using Text Formulas: https://youtu.be/rqypEnQszPk

Part 2 using SUMPRODUCT: https://youtu.be/TzEVSlguFso

In the next video we look at how to use VBA UDF's (User Defined Functions) to solve the challenge (video coming soon).
00:00 Introduction
00:31 Solution with Power Query
09:07 The Data Cleansing Challenge