View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stockwell43 Stockwell43 is offline
external usenet poster
 
Posts: 59
Default Question on forumla

Hello,

I have a spreadsheet with four columns:

Monthly Volume, Minutes per unit, Monthly Hours and Required FTE

If I enter 2 in Monthly Volume and 7 in minutes per unit; my monthly hours
comes out as .23 which is monthly volume*minutes per unit. However, my
Required FTE column is blank, it has the formula monthly hours/173.3 which
are the hours per month of work for an average 20 workday month.

Why is the Required FTE coming out blank? I have the field set to Custom
0,0) is this incorrect? Because people are not receiving full time for their
work.

Thanks!!