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
Bookmarks