How to multiply a text function by a dollar ammount

[Kenya Johnson]

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

 

[Chip Pearson]

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

 

[Kenya Johnson]

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 (e-mail address removed)





.