View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default create a formula to muliply hours times dollars per hour?

If the hours worked are formatted as TIME:

=hours_worked*24*hourly_rate

A1 = hours in TIME format = 40:00
A2 = hourly rate = $45.00

=A1*24*A2

Biff

"sirrafs" wrote in message
...
I need help to create formula to multiply hours worked times hourly rate to
get pay amount.