Rate per hour and auto calculation

K

Kristina

Sorry, I don't know a lot about Excel.
Can you please tell me how I can put rate per hour, so when I put number of hours in "Time" column the program will give me auto calculation in "Amount" column?
Thanx a lot in advance.
 
J

Jason Morin

A2: 25 (rate per hour)
B2: 4 (hours)
C2: =A2*B2 (amount)

HTH
Jason
Atlanta, GA
-----Original Message-----
Sorry, I don't know a lot about Excel.
Can you please tell me how I can put rate per hour, so
Click to expand...
when I put number of hours in "Time" column the program
will give me auto calculation in "Amount" column?
 
K

Kristina

Thanx a lot for the answer, but the problem is i have to put hourly rate only once somewhere on the spreadsheet so it'll auto calculate the amount for the rest of the document. Is it possible? Please help.

----- Jason Morin wrote: -----

A2: 25 (rate per hour)
B2: 4 (hours)
C2: =A2*B2 (amount)

HTH
Jason
Atlanta, GA
-----Original Message-----
Sorry, I don't know a lot about Excel.
Can you please tell me how I can put rate per hour, so
Click to expand...
when I put number of hours in "Time" column the program
will give me auto calculation in "Amount" column?
 
J

Jason Morin

=$A$2*B2

and copy the formula down.

Jason
-----Original Message-----
Thanx a lot for the answer, but the problem is i have to
Click to expand...
put hourly rate only once somewhere on the spreadsheet so
it'll auto calculate the amount for the rest of the
document. Is it possible? Please help.
 
Top