Help

Formula to calculate percentage of day worked on a project per workday

Topic Labels: Formulas
Solved
Jump to Solution
497 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Shira_Loa
5 - Automation Enthusiast
5 - Automation Enthusiast

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!
Screen Shot 2022-10-21 at 2.22.12 PM

1 Solution

Accepted Solutions
TheTimeSavingCo
16 - Uranus
16 - Uranus

Hi Shira, try this {Hours worked} / 8

Field formatting:
Screenshot 2022-10-22 at 12.08.09 PM

Result:
Screenshot 2022-10-22 at 12.07.32 PM

Link to base

See Solution in Thread

2 Replies 2
TheTimeSavingCo
16 - Uranus
16 - Uranus

Hi Shira, try this {Hours worked} / 8

Field formatting:
Screenshot 2022-10-22 at 12.08.09 PM

Result:
Screenshot 2022-10-22 at 12.07.32 PM

Link to base

OMG, I was thinking this would be complex, but it was so simple :person_facepalming:
Long week :laughing:
Thank you!