Hi...

I have a timesheet for employees working on various projects at the same
time. Is there a function within excel where it can search for an employee
name and calculate the total number of hours they have worked even if they
are listed 3 times at different points in the spreadsheet. They are likely to
move around the spreadsheet quite a lot therefore I can't just use a simple
SUM formula.

ANy help would be great cheers !!!