Episode 208 - Time as Text Part 2

In today's episode, someone keyed in hundreds of cells with time and they keyed them all as text. Luckily, though they keyed it in a format that looks exactly like a time Excel would understand. The formula for today's solution is far easier than podcast 207. Episode 208 will show you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!