View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
BoniM BoniM is offline
external usenet poster
 
Posts: 353
Default wages - multiply hours and minutes by number of hours worked

Ummm... I think maybe you missed the hours and minutes thingy. The right
answer would be 637.81. 39 hours and 15 minutes times 16.25 per hour. In
accounting format, that would actually make the hours worked 39.25, making a
little, but oh so important when it's your paycheck, difference. :-)

"chefmike" wrote:

Hi Carol, I ran the numbers you have given and C1= $636.19, I formated C1 for
accounting and the A1 as general, B1 was formated as accounting also; Hope
this helps
chefmike

"Carol (Australia)" wrote:

I'm new to excel and trying to do wages for a small office by multipling
hours and minutes worked by an hourly rate of $16.25 per hour
A1 is 39:15 ( 39 hours and 15 minutes - hours worked for the week)
B1 is $16.25 ( $16.25 per hour worked)
C1 I require the weekly wage I need to pay = A1*B1 but I don't get the
correct answer