Question: Please show your excel formulas/functions In cell H17 create a formula that you can copy down the column that will calculate hours worked for each

Please show your excel formulas/functions

In cell H17 create a formula that you can copy down the column that will calculate hours worked for each row, rounded to the neatest 15 minutes. Copy the formula in cell H17 through the range H17:441 In cell K17 create a formula that you can copy down the column that will calculate hours worked for each row, rounded to the neatest 15 minutes. Copy the formula in cell K17 through the range K17:K21 Check Figures for employees: Total Hours for Sioux Radcoolinator = 42.5 Total Hours for Chantel Washington = 43.25 Total Hours for Carmela Rios = 45.75 Total Hours for Adbi Under = 42.25 Total Hours for Lim Pham = 46 Minutes to round to 0:15:00 Total Hours for employee Employee Sioux Radcoolinator Chantel Washington Carmela Rios Adbi Under Lim Pham Date Employee Sunday, 01/26/2020 Sioux Radcoolinator Sunday, 01/26/2020 Chantel Washington Sunday, 01/26/2020 Carmela Rios Sunday, 01/26/2020 Adbi Under Sunday, 01/26/2020|Lim Pham Monday, 01/27/2020 Sioux Radcoolinator Monday, 01/27/2020 Chantel Washington Monday, 01/27/2020 Carmela Rios Monday, 01/27/2020 Adbi Under Monday, 01/27/2020|Lim Pham Tuesday, 01/28/2020 Sioux Radcoolinator Tuesday, 01/28/2020 Chantel Washington Tuesday, 01/28/2020 Carmela Rios Tuesday, 01/28/2020 Adbi Under Tuesday, 01/28/2020|Lim Pham Wednesday, 01/29/2020 Sioux Radcoolinator Wednesday, 01/29/2020 Chantel Washington Wednesday, 01/29/2020 Carmela Rios Wednesday, 01/29/2020 Adbi Under | Wednesday, 01/29/2020|Lim Pham Thursday, 01/30/2020 Sioux Radcoolinator Thursday, 01/30/2020 Chantel Washington Thursday, 01/30/2020 Carmela Rios Thursday, 01/30/2020 Adbi Under Thursday, 01/30/2020|Lim Pham Time In Before Lunch 8:00:00 AM 6:12:00 PM 2:38:00 PM 2:32:00 PM 10:32:00 AM 7:54:00 AM 8:29:00 AM 9:05:00 AM 12:59:00 PM 11:34:00 AM 12:23:00 PM 7:55:00 AM 9:35:00 AM 7:01:00 AM 12:28:00 PM 6:38:00 AM 11:32:00 AM 2:08:00 PM Time In After Time Out Time Out Before Lunch Lunch After Lunch Hours Worked 11:01:00 AM 12:20:00 PM 4:34:00 PM 10:01:00 PM 10:48:00 PM 3:35:00 AM 7:19:00 PM 8:05:00 PM 12:54:00 AM 7:16:00 PM 7:39:00 PM 11:53:00 PM 4:18:00 PM 5:23:00 PM 9:35:00 PM 11:55:00 AM 12:16:00 PM 4:24:00 PM 12:54:00 PM 2:16:00 PM 5:39:00 PM 1:10:00 PM 2:39:00 PM 6:27:00 PM 4:08:00 PM 5:33:00 PM 8:41:00 PM 2:54:00 PM 3:38:00 PM 7:04:00 PM 5:22:00 PM 6:22:00 PM 9:56:00 PM 12:06:00 PM 1:22:00 PM 4:39:00 PM 2:28:00 PM 3:47:00 PM 7:34:00 PM 10:20:00 AM 10:49:00 AM 1:53:00 PM 4:41:00 PM 6:09:00 PM 10:26:00 PM 10:24:00 AM 11:54:00 AM 3:27:00 PM 2:43:00 PM 4:05:00 PM 11:18:00 PM 6:07:00 PM 6:27:00 PM 11:09:00 PM 7:25:00 PM 8:53:00 PM 2:45:00 AM 1:13:00 PM 2:06:00 PM 6:29:00 PM 2:12:00 PM 3:02:00 PM 9:55:00 PM 3:49:00 PM 4:31:00 PM 9:39:00 PM 12:56:00 PM 1:56:00 PM 8:23:00 PM 1:16:00 PM 1:51:00 PM 8:07:00 PM 6:08:00 PM 7:37:00 PM 3:09:00 AM 2:26:00 PM 8:45:00 AM 9:55:00 AM 11:52:00 AM 8:31:00 AM 9:50:00 AM 1:47:00 PM

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Please show your excel formulas/functions in cell H11 create a formula that you can copy down the column that will calculate the time worked for each employee. Show the 'Time worked, Not rounded'...

Please show your excel formulas/functions In cell G9 create a formula that you can copy down the column that will calculate the balance, but only if a date value has been added for the row. Copy the...

Please show excel formula/function in cell E11 create a formula that you can copy down the column that will calculate the time worked for each employee. in cell F11 create a formula that you can copy...

Please answer all 9 questions and make it very clear what the final answer is - especially for questions 8 and 9 where you must fill in the blanks/choose the correct option(s). I have posted all 9...

ID Salary 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 59.3 26.5 34.1 56.3 46.8 79.5 41.2 23.6 76 22.7 23.8 62.9 41.4 22.3 23.1 46.6 67.6 33.8 24 35 75.2 51.5 22.1 55.4 24.9 24.3 42.9 76.6 75.4...

1 . Go to the Planning Budget tab within your Excel workbook. Prepare the planning budget in column E of the spreadsheet using the following three - step process: Create a formula for actors and...

ID Salary Compa- Midpoint ratio Age Performance Service Gender Rating Raise Degree Gender Grade 1 Copy Employee Data set to this page. The ongoing question that the weekly assignments will focus on...

Set Week Three During this week, we will look at ways of testing multiple (more than two) data samples at the same time. We will continue to use the data and assignment file that we opened in Week 2,...

Scenario Summary Current Values: Original Financing Intermediate Car Changing Cells: Price $ 56,500 $ 21,595 $ 33,999 $ CashBack $ 2,500 $ $ 1,500 $ Months 60 24 36 APR 3.90% 1.90% 2.40% Result...

Develop an M-file function for the secant method based on Figure. And Sec.6.3.2. Along with the initial guess, pass the function as an argument. Test it by duplicating the computation from Example...

If the per-worker production function is given by y = k2, the saving rate (s) is 0.2, and the depreciation rate is 0.1, then the steady-state ratio of capital to labor is: A) 9. B) 4. C) 1. D) 2.

E15.18 (LO 4) (EPS: Simple Capital Structure) Ott Company had 210,000 ordinary shares outstanding on December 31, 2025. During the year 2026, the company issued 8,000 shares on May 1 and retired...

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

7. List behaviors to improve effective leadership in meetings

6. Explain the six-step group decision process

6. Analyze the group dynamics from five of your favorite television shows. See if you can identify the various social and antigroup role types in each of the groups.