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

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

### 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.

 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
 Written by Chandoo Tags: date and time, downloads, homework, iferror, Learn Excel, Microsoft Excel Formulas, MOD(), videos, workday 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)
ISRAEL

• achuyth says:

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

• achuyth says:

Hi Michael,

Thanks for replay.

• achuyth says:

Hi Michael,
If i wanted to ask any suggestion from you on excel, how can i contact you.

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

• naresh says:

Hi Michael,

While I am sending you mail , system shows that email id is wrong..

3. achuyth says:

Thanks Michael.

 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