In A1 input # of people
In A2, input # of hours
In A3:
=A1*A2/8
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Chelle19" wrote:

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!