I need to calculate hours per thousand. Can someone give me the formula to use?
thanks
I need to calculate hours per thousand. Can someone give me the formula to use?
thanks
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: ?
What about this?Originally Posted by vapor77
In C1, enter
=B1*(A1/1000)
and copy down until your requirements are met.
Regards.
BenjieLop
Houston, TX
That worked Great, Thank-you Benjie
You are welcome ... glad that I can help.
Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks