Hello, I am new to doing complicated excel worksheets.
However there is something I have to figure out.
I have a time sheet - within the time sheet I have Employee # (A2) and Employee name (B2). I also have there start time (E2) and end time (F2), I have excel calculating the hours the employee worked (G1)
Down in the spreadsheet I have Employee # (A21) and Employee Name (B21) and total hours (C21)
There can be many rows that have the same employee # and name with more hours.
I need to write an if statement that says if A21 equals any number in column A I need those hours to be calculated together c21
Any help would be appreciated
Bookmarks