LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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!!
 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Forumla tuzdevil Excel Discussion (Misc queries) 2 June 1st 06 10:44 AM
Question about forumla manesh Excel Discussion (Misc queries) 2 April 7th 06 03:18 PM
Help with Forumla WeSt39 Excel Worksheet Functions 2 March 20th 06 11:22 PM
Forumla Help AB Excel Discussion (Misc queries) 1 January 3rd 06 12:06 AM
Forumla Don Excel Worksheet Functions 3 August 9th 05 02:52 AM


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

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

About Us

"It's about Microsoft Excel"