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

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

Thank you and see you around.

### Related articles:

 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 »

### Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.