Forum Discussion
Excel Formulas to calculate the the average FTE
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 ...
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.
Riny_van_Eekelen Thank you I have been working on this for my Church and I am little rusty doing this.
