If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do I calculate the sum of hours if marked x in a schedule?
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. |
#2
|
|||
|
|||
how do I calculate the sum of hours if marked x in a schedule?
please indicate how many 'hours' are represented by each period?
-- hope to help, cm "workinghard" wrote: 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. |
#3
|
|||
|
|||
how do I calculate the sum of hours if marked x in a schedule?
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) -- hope to help, cm "workinghard" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|