Formula to calculate percentage of day worked on a project per workday
Hi community, I’ve built a labor tracker where we will track hours worked per Person/Project/Day. Based upon an 8 hour day, I want to calculate the percent of their day worked on that particular project.
For example, if Veronica works on Project P-035.1 for 4 hrs, she submits that through a form by entering her name (linked field), the date she worked, the project (linked field) and the hours she spent on that project that day. In the case of working 4 hrs, the percentage worked on that project for the day should be 50%. I’m hitting a total blank on how to do that with a formula. (right now the % field is just a manual thing, because I don’t know what the formula should be)
After that, I’m hoping to figure out how to calculate percentage worked on the project for the Month, because that’s how our budget predictions are created, and I want to compare and contrast predictions with actuals.
Any help would be greatly appreciated!
Accepted Solutions
