multiply time and wage
 

I am trying to add hours together and then multiply that by an hourly wage.
For example (in hours:minutes)

38:46 + 24:22 = 63:08 = 63.14 x $8.00 = $505.12

Is there any way to do this in excel or am I asking too much of the program?

Thank you for your help!

KC,

Multiply the time by 24 and format the cell as General then you can multiply
by the wage rate:

63:08 * 24 * 8 = 505.0667

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"KC" wrote in message
...
I am trying to add hours together and then multiply that by an hourly wage.
For example (in hours:minutes)

38:46 + 24:22 = 63:08 = 63.14 x $8.00 = $505.12

Is there any way to do this in excel or am I asking too much of the
program?

Thank you for your help!

=CEILING((A1+B1)*24,0.01)*C1

You need to format both cells A1 and B1, (FORMAT/CELLS/CUSTOM) to this,
[hh]:mm, type it into box just below the word, Type:

Place 38:46 in cell A1 and 24:22 in B1, place the hourly wage of $8.00
in C1 and paste the formula into cell D1.

Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=467287