Rate per hour and auto calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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?
 
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?
 
=$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.
 
Back
Top