Thread
:
Schedule help
View Single Post
#
2
Posted to microsoft.public.excel.misc
paul
Posts: n/a
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
Reply With Quote