multiply time and wage

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

[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


"KC" <[email protected]> wrote in message
news:[email protected]...
>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!

[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