View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Calculating Amount to be Paid

Try this:

=time*24*rate

A1 = 8:00
B1 = 50

=A1*24*B1

Format as General or Number

--
Biff
Microsoft Excel MVP


"Jennifer" wrote in message
...
I am sure this is a simple formula, but for the life of me I cannot figure
this one out at the moment. I have a column oshowing the number of hours
worked (formatted [h):mm )
and need to caluclate if paid $50.00 per hour how much would that
individual
be paid for the number of hours worked?