If you were getting a circular reference error, you probably tried
calculating the $ in the same cells where you had the hours. I'd suggest
that you have a set of columns for hours per job (say D:H for job1 through
job5) and a separate set of columns (say I:M) for dollars per job. Then your
logic would be fine. The $ for job1 would be calculated by a formula in I2:
=$B2*D2. You could copy that formula across (for each job) and down (for
each employee or time period).
HTH. --Bruce

"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