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.webp


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!
 
Back
Top