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

In this video I share an Excel data cleansing challenge. The challenge is to convert time stored as text into time values.
Download the Excel file: https://www.excelcampus.com/filedownload/excel-tables/Text-to-Time-Challenge-Excel-Campus.xlsx

Read the blog post: https://www.excelcampus.com/tips/text-to-time-value-challenge/

The rules are simple:

1. You can use any Excel tool that you'd like (formulas, Power Query, VBA, etc.)

2. The results must be recognized as time values. See video for explanation.

Additional Resources:

How Dates Work in Excel - https://youtu.be/KlCAAQ_tQLA
Full Article: https://www.excelcampus.com/functions/how-dates-work-in-excel/

Beginner's Guide to Excel Tables - https://youtu.be/fJnJTff4Na8
*The challenge file does contain Tables, but you do not have to use Tables to complete this challenge.

How to Submit Your Solution:

Please leave a comment below and explain your solution. You can also upload your file to a cloud sharing service (OneDrive, Google Drive, Dropbox) and share the link.

I will create another video in the next few weeks that walks through some of the most popular or interesting solutions that are submitted.

Have fun & good luck!
00:00 Introduction
00:11 Data Cleansing Challenge
01:06 Data Cleansing Challenge Rules
01:45 Format Cells