Well, the issue I am running into is 40 hours per week per employee so 40
should equal 1 FTE point but trying to get excel to calculate anything less
than 40 hours. So if someone worked only 20 hours it should be .5 FTE where
are 40 hours would be 1 FTE

"Elkar" wrote:

Couldn't you just divide by 40?

=N5/40
=N7/40
=N9/40
etc...

HTH,
Elkar


"RJ Swain" wrote:

I am working on a schedule for my place of business. I am trying to figure
out a way for excel to calculate something we use called FTE. Basically, if
you have an employee work 40 hours a week, that is equal to 1 FTE point. I
would like to be able to take the hours that are totalled up on cells
N5,N7,N9,N11,N13,N15,N17 & N19 and figure out the FTE point value for those
hours in the individual cells.
Any help is appreciated!