Hi Kynhart,

You might try something like this:

A B C D E F G
1 Hours Rate Total Job1Hrs Job1Total Job2Hrs Job2Total
2 40 $10 $400 20 $200 20 $200

Cell A2 Formula:
=Sum(D2+F2)

Cell C2 Formula:
=Sum(E2+G2)

Cell E2 Formula:
=D2*B2

Cell G2 Formula:
=F2*B2

Then you only need to enter values into Column B (Rate), Column D (Job1
Hours) and Column F (Job2 Hours).

Hope that helps.

Regards,
James


"kynhart" wrote:


I have a spreadsheet that I do job costing on and have been using a
calculator to figure out my job costing. Let me give you a sample

A B C D E F

1Hours Rate Total JOB1 JOB 2
2 40 $10 $400 20 20
3
4
5
I NEED TO FIND A FORMULA TO TURN THE 20 HOURS INTO dOLLARS. SOMETIMES
1 PERSON WILL WORK ON 4 OR FIVE DIFFERENT JOBS AND i NEED A MONETARY
VALUE WHERE THE HOURS ARE, SO I HAVE BEEN DOING IT MANUALLY I TRIED
DOING B2*E2 AND IT SAYS I HAVE A CIRCULAR SOMETHING, THAN I TRIED
=(B2*E2) i NEED FOR THE HOURS TO TIMES THE RATE TO GIVE ME A DOLLAR
AMOUNT ON d2 AND E2......wHAT AM I DOING WRONG........PLEASE I AM READY
TO SCREAMMMM MMMMMM


--
kynhart