Schedule help

[phat al]

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

[paul]

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
[email protected]
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
>
>