multiply time and wage

K

KC

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

Sandy Mann

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
[email protected]
Replace@mailinator with @tiscali.co.uk
 
F

Flintstone

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