Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 3rd 06, 06:48 AM posted to microsoft.public.excel.newusers
vapor77
 
Posts: n/a
Default 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   Report Post  
Old February 3rd 06, 10:21 AM posted to microsoft.public.excel.newusers
Dav
 
Posts: n/a
Default 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   Report Post  
Old February 3rd 06, 04:40 PM posted to microsoft.public.excel.newusers
vapor77
 
Posts: n/a
Default 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   Report Post  
Old February 3rd 06, 05:26 PM posted to microsoft.public.excel.newusers
BenjieLop
 
Posts: n/a
Default 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   Report Post  
Old February 3rd 06, 05:54 PM posted to microsoft.public.excel.newusers
vapor77
 
Posts: n/a
Default 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   Report Post  
Old February 4th 06, 01:08 AM posted to microsoft.public.excel.newusers
BenjieLop
 
Posts: n/a
Default 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



Reply
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
Newbie Cell Reference Question... UncleRemus New Users to Excel 2 October 30th 05 01:02 PM
Newbie and use of lookup question? manasi Excel Discussion (Misc queries) 6 September 21st 05 01:03 PM
Newbie With A Question Michael Excel Worksheet Functions 0 July 28th 05 11:50 PM
Newbie Question: Data/Sort [email protected] New Users to Excel 1 February 22nd 05 12:37 AM
Newbie question Doh New Users to Excel 5 December 16th 04 10:31 PM


All times are GMT +1. The time now is 07:00 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017