time format multiplied by hours worked ?

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
> >
> >