How many hours did Billy work? [Solve this]
Here is a simple but tricky problem.
Imagine you are the HR manager of a teeny-tiny manufacturing company. As your company is small, you just have one employee in the shop floor. He is Mr. Billy.
As this is a one person production facility, Billy has the flexibility to choose his working hours. At the end of each week, Bill would email you a file that says start & end times of his work. You are supposed to look at this file, figure out how many hours he worked and pay him accordingly.
So you are looking at the recent data Billy sent.
So how would you calculate the total hours?
- Note: Billy doesn’t know much about Excel.
Go ahead and answer the question.
What formula would you write in Hours worked column for each day?
Assume Start times are in C4:C9 and End times are in D4:D9
Please post your answers in comments section. Billy is waiting for his pay!!!
PS: In case you want a sample file to play with this data & work, download it here.
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.
Leave a Reply
|« Changing stubborn opinions with visualizations [case study]||What functions is Excel missing ? »|