Employee hours - total for each employee

Hi guys, I need your help!
I have been trying for weeks to figure out a formula to summarize hours for each employee from my Excel spreadsheet. I didnt find any solution

I track hours for each job in a day. For each work I have put down a name, start time and end time - for each person involved. There can be up to 10 people working together on a job.
There can be unlimited amount of jobs per month.

What I need is to find a formula which will bring list of names and monthly total of hours for each person.

Example:
alpha - monthly total 50 hours
beta - monthly total 32 hours (those numbers are just as example, they are NOT from my speadsheet)
etc.

Can you help please? Employee hours.xlsx

How you found this:

Originally Posted by 1joie

alpha - monthly total 50 hours
beta - monthly total 32 hours

from your data?


Write list of employees
alpha
beta
etc. in A30 and down
B30 write array formula (commited Ctrl+Shift+Enter instead of just Enter):

=SUM(IF($B$2:$H$7=$A30,$D$2:$J$7-$C$2:$I$7,""))

and copy down.
If needed (probably needed for real data) use custom format for cell B30 and down [hh]:mm

If you set up your data this way you can use a PivotTable to summarize it. Right click the PivotTable and choose "Refresh" to update.

HAve you comitted it as array formula? See attached.