Calculation Question

[Guest]

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!

 

[Guest]

Couldn't you just divide by 40?

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

HTH,
Elkar

 

[Guest]

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

 

[Pete_UK]

If you had 20 in cell N5, then Elkar's formula would give you 20/40 or
0.5, so what's the problem?

If your hours are stored in Excel time format and formatted as [h],
then you would need to multiply by 24 to get the correct answer, as
times are stored as fractions of a 24-hour day, i.e. the formula would
have to become:

=N5*24/40

etc. and format the cell as Number with 1 or 2 decimal places.

Hope this helps.

Pete

 

[Guest]

HA HA! The evil *24 was missing.. thank you all for your help! greatly
appreicated!

If you had 20 in cell N5, then Elkar's formula would give you 20/40 or
0.5, so what's the problem?

If your hours are stored in Excel time format and formatted as [h],
then you would need to multiply by 24 to get the correct answer, as
times are stored as fractions of a 24-hour day, i.e. the formula would
have to become:

=N5*24/40

etc. and format the cell as Number with 1 or 2 decimal places.

Hope this helps.

Pete

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

 

[Pete_UK]

Thanks for feeding back.

Pete

HA HA! The evil *24 was missing.. thank you all for your help! greatly
appreicated!

If you had 20 in cell N5, then Elkar's formula would give you 20/40 or
0.5, so what's the problem?

If your hours are stored in Excel time format and formatted as [h],
then you would need to multiply by 24 to get the correct answer, as
times are stored as fractions of a 24-hour day, i.e. the formula would
have to become:

=N5*24/40

etc. and format the cell as Number with 1 or 2 decimal places.

Hope this helps.

Pete

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

:

Couldn't you just divide by 40?

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

HTH,
Elkar


:

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!