newbie question

[vapor77]

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

thank

 

[Dav]

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

 

[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:

 

[BenjieLop]

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

 

[vapor77]

That worked Great, Thank-you Benji

 

[BenjieLop]

You are welcome ... glad that I can help.

Regards.