Adding up total hours worked on employee schedule using various criteria

C

CGF2704

Joined
Mar 6, 2016
Messages
1
Reaction score
0
I have an employee schedule that lists the shifts worked on a weekly basis. The shifts are entered into the sheet using shift names rather than actual times. The hours (value) of each shift varies depending upon the number of movements in the day - on days with 3 movements most are 8, on days with 2 movements they vary from 5-8. I need for the last column of the schedule to show the total hours worked for each person, taking into account the difference in the daily schedule (movements).

example.jpg


Currently I'm using the following formula in column G
=SUM(COUNTIF(B4:E4,{"OKL","OAF","SECU","C","FC","SS1"})*{6,6,5,5,6,8})

However this doesn't take into account the difference between 2 & 3 movement days. I've tried various combinations of LOOKUP, VLOOKUP, IF, etc. but haven't been able to make work.

Any thoughts from the pros?

Thanks for the help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Total Hours Worked Each Day 5
Recalculating schedule 1
employee schedule 3
Payroll attendance 4
Running total of hours based on last 7 days 1
EMPLOYEE WEEKLY SCHEDULE 6
SUM hours by month and day? 4
Number of hrs worked in a week, based on dates in a different column 1

Top