If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
newbie question
I need to calculate hours per thousand. Can someone give me the formula to use? thanks -- vapor77 ------------------------------------------------------------------------ vapor77's Profile: http://www.excelforum.com/member.php...o&userid=31132 View this thread: http://www.excelforum.com/showthread...hreadid=507971 |
#2
|
|||
|
|||
newbie question
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 -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=507971 |
#3
|
|||
|
|||
newbie question
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 ------------------------------------------------------------------------ vapor77's Profile: http://www.excelforum.com/member.php...o&userid=31132 View this thread: http://www.excelforum.com/showthread...hreadid=507971 |
#4
|
|||
|
|||
newbie question
vapor77 Wrote: 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: ? What about this? In C1, enter =B1*(A1/1000) and copy down until your requirements are met. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=507971 |
#5
|
|||
|
|||
newbie question
That worked Great, Thank-you Benjie -- vapor77 ------------------------------------------------------------------------ vapor77's Profile: http://www.excelforum.com/member.php...o&userid=31132 View this thread: http://www.excelforum.com/showthread...hreadid=507971 |
#6
|
|||
|
|||
newbie question
You are welcome ... glad that I can help. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=507971 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Saving calculated field results.....a newbie question! | S Kahn | General Discussion | 4 | September 2nd, 2005 03:27 AM |
Frustrated Newbie - Lookup Question | LMWilliams | Database Design | 2 | June 29th, 2005 06:08 AM |
Newbie Question: MS Access - Website Interactions | Nick | New Users | 1 | June 27th, 2005 10:49 PM |
Newbie question on calculated fields | Nick Xylas | General Discussion | 3 | June 7th, 2005 05:08 PM |
Q: newbie data access page question | MarkD | General Discussion | 1 | July 7th, 2004 10:05 PM |