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!!
|