How to multiply a text function by a dollar ammount

I am trying to create a time sheet that will calculate
the number of hours and minutes and multiply that number
by a rate of pay. I have been having problems because
the formula used to calculate the number of Hours and
minutes is a text function. Can anybody help me?

Kenya

Kenya,

If you have a time value for the elapsed time, multiply that by 24 then by
the wage rate. E.g.,

=A1*24*wage

If the time value is indeed text, use the TIMEVALUE function to convert it
to a time, then multiply by 24 and the wage. E.g.,

=TIMEVALUE(A1)*24*wage


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Kenya Johnson" wrote in message
...
I am trying to create a time sheet that will calculate
the number of hours and minutes and multiply that number
by a rate of pay. I have been having problems because
the formula used to calculate the number of Hours and
minutes is a text function. Can anybody help me?

Kenya

Thank you very much.

Kenya

-----Original Message-----
Kenya,

If you have a time value for the elapsed time, multiply
that by 24 then by
the wage rate. E.g.,

=A1*24*wage

If the time value is indeed text, use the TIMEVALUE
function to convert it
to a time, then multiply by 24 and the wage. E.g.,

=TIMEVALUE(A1)*24*wage


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Kenya Johnson" wrote in message
...
I am trying to create a time sheet that will calculate
the number of hours and minutes and multiply that
number
by a rate of pay. I have been having problems because
the formula used to calculate the number of Hours and
minutes is a text function. Can anybody help me?

Kenya


.