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

This is the fourth video in a series of solutions for our Data Cleansing Challenge. In this video I explain how to use User Defined Functions (UDFs) in VBA 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/vba/convert-text-to-time-values-udf-vba

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 solutions posted by Jon Peltier, Graham, and Charles Marshall.

Each solution uses a custom function (UDF) that is written with VBA code. The UDFs allow us to pass the text through as an argument, then process/calculate the result with various coding techniques in VBA, and output the result to the cell.

Checkout my previous video on How to Write User Defined Functions in Excel with VBA if you are new to UDFs:
https://youtu.be/JbpDCBMMpkA


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

Part 3 using Power Query: https://youtu.be/1h94nq4if28

Please leave a comment below with any questions or suggestions. Thank you! And thanks again to everyone that participated. I learned a lot and I hope you did too.
00:00 Introduction
00:10 The Data Cleansing Challenge
00:49 UDF Solutions with VBA