New to Excel, trying to figure out functions.

[kasuals]

Ok, well I maintain a database of consultants for CNC programmers and network admins at my shop. I'm keeping track of time and labor costs.

I have a static value of say $48.00 for each hour a rep is pulled away from their usual duties. I'd keep my spreadsheet like so:

Date Desc Employee Labor (Hours) Labor Cost
1/1/08 Blah Me 1.5 $72.00

Now what I'm not sure how to do is convert the hours using the static variable of $48.00 into the total labor cost for that row.

I looked through the Insert->Function deal and honestly it didn't give me much help... then again I'm not even sure what I'm looking for.

Any help would be great, I'm sure its a snap to you guys but this is outta my realm

http://www.angsttechnology.com

- "Delightfully confusing..." raves The New York Times

-kas

 

[chipk]

assuming your header rows are lined up correctly, the formula in cell e2 would be:

=d2*48.00

Those cells would need to be formatted for decimals and $ symbols, but that formula will do what you want. Click the cell, grab the little black box in the lower right corner and drag that to the bottom of your data.

 

[SkipVought]

Hi,

I'm a big advocate of Named Ranges.

Name the Cell Range that contains your constant of 48, let's say [/b]LaborRate_Other[/b]

Then your formula, which appears to be in column D, row 2...
[tt]
=C2*LaborRate_Other
[/tt]
If your rate changes, you make ONE change and all the places it's used, recalculates.


Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[kasuals]

Thanks Chip, actually what I did was define $48.00 at the top of my spreadsheet in the hourly rate section then refer to it with =E2*$D$6

Now, my only thing is (and I have read a few tutorials) getting every line in F from 10 to 100 to reflect the function for the E column in its respective line. Is there a way to get all F columns without modifying the =E for each column?

http://www.angsttechnology.com

- "Delightfully confusing..." raves The New York Times

-kas

 

[SkipVought]

Take a look at Data > List

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}