Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forumla | Excel Discussion (Misc queries) | |||
Question about forumla | Excel Discussion (Misc queries) | |||
Help with Forumla | Excel Worksheet Functions | |||
Forumla Help | Excel Discussion (Misc queries) | |||
Forumla | Excel Worksheet Functions |