is this what you are looking for ??

In sheet 1
Col A Names, Col B hours

sheet 2
Col A names , in B2 put this formula =SUMIF(Sheet1!A2:B15,Sheet2!
A2,Sheet1!B2:B15)

the format the col B as [hh]:mm



On Oct 20, 11:12*pm, edmar42 <Granma @discussions.microsoft.com
wrote:
A payroll that has several employees going to numerous places throughout a
months time period and bills either in whole hrs or 1/2 increments. Master
sheet has name of places with *employee name with billable hrs. *2nd sheet
would have employee name. Is there a way for the 2nd sheet to pick up all
hours for that employee?