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