Tracking Request Hours and Placing Requests into a bucket based on # of hours used
First, I appreciate all the help and suggestions, since I'm struggling with how to accomplish this task.
I have a sheet that contains requests,(assigned a unique number) as requests are approved the # of hours is captured for each request.
Each billable bucket is capped at 1800 hours and requests can spill over from one bucket to another (i.e. request 1 is 2200 hours, would fill bucket 1 and 400 hours would go into bucket 2)
Here is what I'm trying to do:
- When a request is approved know what bucket it is going to be billed in based on the hours remaining in the current bucket. Would ideally update the original request sheet.
- Maintain a log of all billable buckets and show the request number associated with that bucket and the number of hours used. If a request fills a bucket the remaining hours go into the next bucket.
- Be able to show the current bucket and the number of hours remaining in that bucket.
I'm open to adding any additional sheets as needed, including add helper columns to my original sheet.
Frank Smith, PMP
Assistant Director | IT Special Projects Mgr.
Oregon Parks & Recreation Department
If my response helps, please mark it as an accepted answer. 😎
Help Article Resources
Check out the Formula Handbook template!