 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2006newbie question
I need to calculate hours per thousand. Can someone give me the formul to use? thank Without seeing your sheet (hours)/(thing you want to standardise by)*1000 So for example if hours are in A1 If number of staff is in B1 If you want hours per thousand staff in C1 Enter in C1 =A1/B1*1000 Regards Dav  SignatureDav Thanks for the quick response. But I still can't get the result I'm looking for. What I am trying to calculate is hours per thousand feet, For example: Column A has my total feet : 16522 Column B has my hours per thousand number: 3.5 Column C will have my total hours: vapor77 Wrote: > Thanks for the quick response. > But I still can't get the result I'm looking for. [quoted text clipped - 4 lines] > Column B has my hours per thousand number: 3.5 > Column C will have my total hours: ? What about this? In C1, enter =B1*(A1/1000) and copy down until your requirements are met. Regards -- BenjieLo That worked Great, Thank-you Benji |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.