We record each employee's billable time each week with the goal of making sure they are at least 75% utilized each week. In a row, we have the employees name and the hours they worked that week. The goal is to be able to see their total utilization as the weeks tick by. Attached is what the spreadsheet looks like, I'm just at a loss on how to figure each week and not calculate weeks (cells that are empty).
As you can see, the formula that I am currently using, doesn't calculate correctly. What I would like to do is somehow take the possible hours that are listed at the top and divide them by the actual worked hours in Bob's row. But then how do I not include weeks that are not completed yet? thanks for any help you can provide...
Dave
As you can see, the formula that I am currently using, doesn't calculate correctly. What I would like to do is somehow take the possible hours that are listed at the top and divide them by the actual worked hours in Bob's row. But then how do I not include weeks that are not completed yet? thanks for any help you can provide...
Dave