Calculating Billy’s total working hours [solution & discussion]

Posted on by

Few days ago, I asked you “How many hours did Billy work?” There were more than 100 responses with lots of innovative solutions.

So today, let’s examine various ways to calculate total working hours given start & end times of tasks. Please watch below video.

Calculating Bill’s total working hours (video)

Can’t see the video? Please visit Chandoo.org on YouTube to enjoy it.

Download the Solution Workbook

Please click here to download the solution workbook. Examine the formulas to understand more.

Want more challenges?

If you want to quickly improve your Excel skills, there is no better way than taking up challenges. Check out below challenges, home work problems & puzzles to increase your awesomeness quotient.