Tallying an employee hour schedule

1. Tallying an employee hour schedule

I am trying to grasp how I can make a linked workbook to search and employee by name on one sheet and calculate the hours worked for that employs name over the course of a week long schedule? I need the excel formula to search the employee name over large spread of cells, then take the number of hours in the cell below that name and drop it into another page to then be totaled. I am trying to keep OT in check with this tool and w are too small for software to do this for our company.
Thank you

2. Re: Tallying an employee hour schedule

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Please note that the Paperclip icon (Attachments button) does not work on this forum.

Hope this helps.

Pete

3. Re: Tallying an employee hour schedule

The second tab shows Drivers hours, and these are just numbers my manager plugs in after tallying manually. I want the cell to search the driver name, then pull the cell hours for that name and date onto the driver hour sheet. Does that make sense?

4. Re: Tallying an employee hour schedule

Hello CTPHOWE and Welcome to Excel Forum.
This proposed solution requires some modification to the spreadsheets:
1) The dates in column A of the Dec 4-17 sheet need to be actual dates which may be formatted dddd d as shown.
2) The names (ChrisR and Dank etc.) need to match on both the Dec 4-17 sheet and the Winter sheet (row 2).
The following array entered formula* may then be used, as demonstrated in cells B12:C18 on the Winter sheet:
Formula:
`Please Login or Register  to view this content.`

*Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Let us know if you have any questions.

5. Re: Tallying an employee hour schedule

Thank you for this! However, when I recreate the formula in the real sheet, and I click the CTRL+SHIFT+ENTER, it does not give me the braces, and the formula does not compute. Why is that? Any suggestions?

6. Re: Tallying an employee hour schedule

Press the those keys simultaneously (hold the Ctrl and Shift keys down while pressing the Enter key).
Let us know if you have any questions.

There are currently 1 users browsing this thread. (0 members and 1 guests)