Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

Topic Labels: Formulas
Solved
Jump to Solution
159 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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!