Calculating Billy’s total working hours [solution & discussion]
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.
- Check if 2 ranges have same values
- How long is the longest winning streak?
- What is the average speed of this road trip?
- Calculate maximum change
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Use Paste Special to multiply (or add, divide etc.) a range with a variable [quick tip]||Introduction to Slicers – What are they, how to use them, tips, advanced techniques & interactive reports using Excel Slicers »|