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

Posted on June 22nd, 2015 in Excel Challenges - 7 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.

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

7 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)
    ISRAEL

    • achuyth says:

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

      • Michael (Micky) Avidan says:

        @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

  2. Michael (Micky) Avidan says:

    @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

  3. achuyth says:

    Thanks Michael.

Leave a Reply