Schedule help
 

I have a couple of questions

How do I add the total of hours for five people on one schedule typed
up in a month schedule? Due to multiple people doing 4 on n 2 off just
totaling the lines mixes everyone up.


is there a monthly program i could use? can you advice a good one? or
free would be beter


--
phat al
------------------------------------------------------------------------
phat al's Profile: http://www.excelforum.com/member.php...o&userid=34988
View this thread: http://www.excelforum.com/showthread...hreadid=547288

Schedule help
 

list of names in B5:B22,daily hours in F5:F22
=sumif(B$5:B$22,"name",F$5:F$22),copy down and change names as required
--
paul

remove nospam for email addy!



"phat al" wrote:


I have a couple of questions

How do I add the total of hours for five people on one schedule typed
up in a month schedule? Due to multiple people doing 4 on n 2 off just
totaling the lines mixes everyone up.


is there a monthly program i could use? can you advice a good one? or
free would be beter


--
phat al
------------------------------------------------------------------------
phat al's Profile: http://www.excelforum.com/member.php...o&userid=34988
View this thread: http://www.excelforum.com/showthread...hreadid=547288