Question on forumla
With that custom format you are only displaying to 1 decimal place,
whereas the number is actually:
0.001346413
when formatted as General.
Hope this helps.
Pete
On Dec 5, 4:24*pm, Stockwell43
wrote:
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!!
|