Hours as a % of a 40 hour work week

brhea110891

What formula would I use if I ask a team member to enter the hours they spent on a project (via form) and then on my sheet I want to convert this to a weekly % allocation?

Thank you,

Becky

brhea110891

Never mind. I figured it out - =([Week project hours]@row / 40) and the column is a % format

Genevieve P.

Hey @brhea110891

I'm glad you figured it out! Thanks for posting your solution.

Cheers,

Genevieve