Please help.

In one cell I have number of hours worked in time format e.g. 8:00 hours.
In the next cell I have the hourly pay rate in currencly format e.g. $22.50
In the next cell I want to be able to multiply 8.00 hours by $22.50 to get
the daily amount of pay but when I multiply the 2 cells I get some figure
which is way off. Does anyone know how I can do this ?

Thank You

If you have the 8:00 formatted as time, you need to multiply it by 24.
Try something like:
=24*A1*B1

tj

"Brett" wrote:

Please help.

In one cell I have number of hours worked in time format e.g. 8:00 hours.
In the next cell I have the hourly pay rate in currencly format e.g. $22.50
In the next cell I want to be able to multiply 8.00 hours by $22.50 to get
the daily amount of pay but when I multiply the 2 cells I get some figure
which is way off. Does anyone know how I can do this ?

Thank You

Forgot to add--Make sure you format the answer as something other than Time.
It will likely be formatted as time until you change it.

tj

"tjtjjtjt" wrote:

If you have the 8:00 formatted as time, you need to multiply it by 24.
Try something like:
=24*A1*B1

tj

"Brett" wrote:

Please help.

In one cell I have number of hours worked in time format e.g. 8:00 hours.
In the next cell I have the hourly pay rate in currencly format e.g. $22.50
In the next cell I want to be able to multiply 8.00 hours by $22.50 to get
the daily amount of pay but when I multiply the 2 cells I get some figure
which is way off. Does anyone know how I can do this ?

Thank You