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.


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:

Written by Chandoo
Tags: , , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

9 Responses to “Calculating Billy’s total working hours [solution & discussion]”

  1. Michael (Micky) Avidan says:

    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)

    • achuyth says:

      Hi Michael (micky) please share the link of your English excel language

      • Michael (Micky) Avidan says:

        I hardly have a Hebrew blog and none in English.
        Michael (Micky) Avidan
        “Microsoft® Answers” – Wiki author & Forums Moderator
        “Microsoft®” MVP – Excel (2009-2015)

  2. Michael (Micky) Avidan says:

    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)

  3. achuyth says:

    Thanks Michael.

Leave a Reply

« »