+ Reply to Thread
Results 1 to 6 of 6

Tallying an employee hour schedule

  1. #1
    Registered User
    Join Date
    12-04-2017
    Location
    USA
    MS-Off Ver
    Windows 10
    Posts
    3

    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. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    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. #3
    Registered User
    Join Date
    12-04-2017
    Location
    USA
    MS-Off Ver
    Windows 10
    Posts
    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?
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    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: copy to clipboard
    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.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Registered User
    Join Date
    12-04-2017
    Location
    USA
    MS-Off Ver
    Windows 10
    Posts
    3

    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. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Employee breakdown by half hour on rotating 6 week schedule
    By aferguson in forum Excel Formulas & Functions
    Replies: 28
    Last Post: 05-30-2016, 01:59 PM
  2. how many employee working per hour
    By Mduntley in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-19-2015, 04:40 PM
  3. Employee Schedule
    By Wm172 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-03-2013, 03:58 PM
  4. Replies: 8
    Last Post: 07-15-2013, 07:13 PM
  5. employee schedule help
    By kcjaries78 in forum Excel General
    Replies: 3
    Last Post: 04-30-2009, 10:58 AM
  6. employee schedule
    By wingsofeagle in forum Excel General
    Replies: 1
    Last Post: 07-03-2008, 09:16 AM
  7. Employee Schedule
    By henrikjt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-22-2006, 10:16 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1