How to multiply a text function by a dollar ammount

  • Thread starter Thread starter Kenya Johnson
  • Start date Start date
K

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





.
Click to expand...
 
Back
Top