=(B2*D2)+(B3*D3)

will give the total for Job 1,
assuming hourly wage is in B col and
Job 1 hrs are in D col.




kynhart Wrote:
I am trying to get a formula for my job costing worksheet. example
Hours wages Total Job l Job 2 job3
Job 4
40 $10 $400 16hrs 8 hrs 8 hrs
8 hrs,
32 $12 $384 16hrs 16 hrs.

What kind of formula would I use to get dollar amount for each job...
I went to Excel classes and the teacher could not help me, go figure.


--
kynhart


--
Lilliabeth
------------------------------------------------------------------------
Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741
View this thread: http://www.excelforum.com/showthread...hreadid=477410