Today, Leslie has a schedule for the week and she needs to total the hours. The solution appears to be complicated to arrive at the proper result, so… a A Macro? No… With dashes, no dashes things become a little more involved… but Bill arrives at a 7 Function solution, and then starts to Duel himself in a ‘Solo Dueling Excel’. Follow along with Episode #1690 as MrExcel works out a solution to Totaling these hours.

[youtube=http://youtube.com/watch?v=oBSurSmFU28]

"Learn Excel 2007 through 2010 from MrExcel" by Bill Jelen…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

Visit us: MrExcel.com for all of your Microsoft Excel Needs!