View Single Post
  #2   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

=A1*B1*24

"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