+ Reply to Thread
Results 1 to 6 of 6

newbie question

  1. #1
    Registered User
    Join Date
    02-03-2006
    Posts
    5

    newbie question

    I need to calculate hours per thousand. Can someone give me the formula to use?

    thanks

  2. #2
    Forum Expert
    Join Date
    09-09-2005
    Location
    England
    MS-Off Ver
    2007
    Posts
    1,500
    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

  3. #3
    Registered User
    Join Date
    02-03-2006
    Posts
    5
    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: ?

  4. #4
    Forum Contributor
    Join Date
    06-23-2004
    Location
    Houston, TX
    Posts
    571
    Quote Originally Posted by vapor77
    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
    Houston, TX

  5. #5
    Registered User
    Join Date
    02-03-2006
    Posts
    5
    That worked Great, Thank-you Benjie

  6. #6
    Forum Contributor
    Join Date
    06-23-2004
    Location
    Houston, TX
    Posts
    571
    You are welcome ... glad that I can help.

    Regards.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1