Hello,
I have a pivot table that essentially shows the number of hours a resource worked for every week of 2011. I am trying to come up with a formula that will look through all the weekly hours and note if a resource has worked over 40 hours. I am having an issue with this, can anyway provide some guidance on if this can be done?
Formula Name Week 1 Week 2 Week 3 week 4 John 30 45 39 40 Jane 40 46 44 32
What would the formula be in the above example? The result could state "Over 40".
Is there another formula that could give me a result that reflects which weeks the resource was over 40 and maybe another one to tell my what the hours were for those weeks?
Thank you in advance,
Kim
Bookmarks