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

Solved
Jump to Solution
410 1
cancel
Showing results for
Search instead for
Did you mean:
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!

1 Solution

Accepted Solutions
16 - Uranus

Hi Shira, try this `{Hours worked} / 8`

Field formatting:

Result:

Link to base

2 Replies 2
16 - Uranus

Hi Shira, try this `{Hours worked} / 8`

Field formatting:

Result:

Link to base

5 - Automation Enthusiast

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