Calculating Employees hours in Macros

**first_n_goal** · 05-31-2014, 10:25 PM

Im doing a spreed sheet to calculate employees hours. I have the employees names in column R and their hours in column S. example R5 = Mike S5 = 8. I need to search column R for all the mike's and total his hours, then move to the next employee and so on... I have already sorted the employees names so that all the names and hours correspond and starting in column R5 and S5 until the proceeding row is blank and then paste the results in column B5 (employee name) and D5(total hours)

Any help would be appreciated. Thanks

**majosum** · 06-01-2014, 04:43 PM

You could use a SUMIF formula for this with no sort necessary. For example, in cell D5, enter the following formula:

=SUMIF(R:R,B5,S:S)

Then, drag this formula down column D and you will get the total hours for all employees.

**first_n_goal** · 06-01-2014, 08:09 PM

Thanks but i Need a formula to search by name and then calculate the hours in the next column.

A1 Tara B1 8:00
A2 Tara B2 6:30
A3 Steven B3 8:00
A4 Mike B4 5:30
A5 Mike B5 7:25

**HaroonSid** · 06-01-2014, 11:15 PM

upload sample workbook

**first_n_goal** · 06-02-2014, 10:39 AM

I was able to pull the names from the original spreadsheet, sort them according to names I'm just not sure how to calculate their total hours for each week. The problem is the names will be continuously changing according to the schedule, so i need a formula to sort by names and calculator their hours on the following column. and paste there names in column B5 and there hours in C5 and so on....

Thanks in advance for all you guys help.