Excel Formulas to calculate the the average FTE

[Lcoumbe]

I am working on the Paycheck Protection Program Forgiveness work sheet and I need an excel formula that calculates the average full time equivalent for each employee. A full time employee working 40 hours a week would be 1.0 an employee working 20 hours a week would be .5 and one working 10 hours would be .25.     

[#2]

@Lcoumbe Such formula could look like:

=A1/40

.... where A1 is the cell that contains the working hours per week (adjust the reference to your liking). Format the cell that holds this formula as a two-decimal number. 

Or, if you want to make it more dynamic, replace the 40 by a cell reference where you have the full-time working hours.

[#3]

@Riny_van_Eekelen Thank you I have been working on this for my Church and I am little rusty doing this.