I have an employee time sheet that has multiple worksheets for every day of the week (Mon-Sat). I often have over 20 different employees on the sheet and the employees are not always the same each day on the sheet. I am trying to figure out how I can add the total hours an employee has worked on my job each week. Is there a formula that can :
1. Find Employee 's hours on each work sheet(Even if it is entered in a different cell on each work sheet)
2. Return the total hours of Employee A
I am not sure if Excel is capable of this, but I am sure someone out there does!
Thanks ahead of time
1. Find Employee 's hours on each work sheet(Even if it is entered in a different cell on each work sheet)
2. Return the total hours of Employee A
I am not sure if Excel is capable of this, but I am sure someone out there does!
Thanks ahead of time