View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CM CM is offline
external usenet poster
 
Posts: 136
Default 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.