Thread
:
multiply time and wage
View Single Post
#
2
Sandy Mann
Posts: n/a
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!
Reply With Quote