Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |