Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3. Sergio wants you to enter formulas to calculate the number of hours Mia Hakim worked each day and for the week. In cell G9,
3. Sergio wants you to enter formulas to calculate the number of hours Mia Hakim worked each day and for the week. In cell G9, insert a formula without using a function that calculates the total hours worked. Add the difference of the first time out (cell D9) and the first time in (cell C9) to the difference of the second time out (cell F9) and the second time in (cell E9), and then multiply the result by 24 to find the total hours. Copy the formula in cell G9 to the range G10:G15 to calculate the total hours for each day
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started