Menu
Calculating Billy’s total working hours [solution & discussion]
Excel Challenges - 9 comments
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
Hello Awesome...
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.
I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.
Thank you and see you around.
Related articles:
|
At Chandoo.org, I have one goal, "to make you awesome in Excel & Power BI". I started this website in 2007 and today it has 1,000+ articles and tutorials on data analysis, visualization, reporting and automation using Excel and Power BI. 
9 Responses to “Calculating Billy’s total working hours [solution & discussion]”
I'm sorry to say that only 2 (out of 5) formulas are capable to handle a 24 hours shift (Col. G & I)
As for the formula in Col. J - try:
START: 06:00 AM
END: 11:30 PM
and you'll get a round(!) figure of 17.00 instead of 17.30 hours and so poor Billy lost half an hour...
Multiply that lost 25
I rest my case.
---------------------------
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2015)
ISRAEL
Hi Michael (micky) please share the link of your English excel language
blog.
@achuyth,
I hardly have a Hebrew blog and none in English.
—————————
Michael (Micky) Avidan
“Microsoft® Answers” – Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2015)
ISRAEL
Hi Michael,
Thanks for replay.
Hi Michael,
If i wanted to ask any suggestion from you on excel, how can i contact you.
@achuyth,
You may try via Mail: micky-atapuz.co.il
Please try to avoid as much as possible because my spare time is very short.
Please remember that my mother's tongue was not English - so, please, write in details & attach a sample workbook.
———————------——
Michael (Micky) Avidan
“Microsoft® Answers” – Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2015)
ISRAEL
Hi Michael,
While I am sending you mail , system shows that email id is wrong..
@naresh,
Try: micky-a@tapuz.co.il
Michael
Thanks Michael.