newbie question

  • Thread starter Thread starter vapor77
  • Start date Start date
V

vapor77

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
 
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 said:
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: ?
Click to expand...

What about this?

In C1, enter

=B1*(A1/1000)

and copy down until your requirements are met.

Regards
 
Back
Top