View Single Post
  #2   Report Post  
Sandy Mann
 
Posts: n/a
Default

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!