Forum Discussion

Lcoumbe's avatar
Lcoumbe
Copper Contributor
Oct 30, 2020

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 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.     

Formulas and Functions

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Oct 30, 2020

    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.

Resources