LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Formula Help

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 M wrote:
In A1 input # of people
In A2, input # of hours
In A3:
=A1*A2/8
Hi All -

[quoted text clipped - 9 lines]

Thanks!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"