how do I calculate the sum of hours if marked x in a schedule?

W

workinghard

hi I have a schedule with x's placed if a person(rows) is working that
period(column headers). How do I create the formula to add the total number
of hours worked for each person ?
Ie,
A B C D
E
8:30-9:50 10:30-3 5-10
Total hours
1 name 1 x x
2 name 2 x x
3 name 3 x x

Thank you.
 
C

cm

assuming 1.3 hours for period in column B, 4.5 hours for period in column C
and 5 hours for period in column D:

in column E: =IF(B2="x",1.3,0)+IF(C2="x",4.5,0)+IF(D2="x",5,0)
 

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

Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Countifs or a pivot 1
How do I create a calculated field on the Total in a pivot table? 0
Formula to calculate the data of the last order 1
Calculate the difference betwen two columns -two dates 3
Scehduling in excel 0
How do I calculate time in excel (clock in and clock out 3
Sum rows if muliple cells meet criteria but not others 4

Top