Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
employee schedule with hours | Excel Worksheet Functions | |||
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
Schedule hours calculation | Excel Discussion (Misc queries) | |||
How can I calculate hours in a Hourly schedule in Excel? | Excel Worksheet Functions | |||
how do I calculate hours from a schedule | Excel Worksheet Functions |