Formula Help

C

Chelle19

Hi All -

I am trying to figure out how to populate a different output by entering in a
different value. For instance, there are employees that can work 20 hours, 25
hours or 30 hours. I need to formulate this so if someone puts in 20 hours it
will take the number of people working 20 hours and process it into an FTE
(full time equivalent). Meaning, if I hire 100 people to work 20 hours per
week, but need to figure out how many people that would be, I, of course, can
figure it to be 200 people to equal out to FTE count. So, if I need 200
people, I want them to work x hours then it will tell me how many people that
translates to in FTEs. Hope that make sense?

Thanks!
 
C

Chelle19

So if I want to input the number of hours into one cell, and have it figure
out what the FTE conversion would be based on another cell with number of
people and not FTEs, it would do that for me? Also, how would I write the
formula: If cell A1 = 20 it would come out to this number of FTEs in Cell A2,
but if they put put 25 or 30 in cell A1, how can I get that to calculate the
number of FTEs if they put any of those 3 values in cell A1.

ANother example:

I need 150 FTEs, the people I am all going to be hiring will be part time
workers. So, If I need to figure out the FTE conversion on whether these
people will be working 20 or 25 or 30 hours and get what the FTE number would
be, is that possible?

Thanks!

Luke said:
In A1 input # of people
In A2, input # of hours
In A3:
=A1*A2/8
[quoted text clipped - 9 lines]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top