create a formula to muliply hours times dollars per hour?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need help to create formula to multiply hours worked times hourly rate to
get pay amount.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiply hours/minutes times dollars for total dollar amount 1
Work hours with overtime 2
Time calculations for Scheduled Time vs. Actual Time Worked 1
Time calculations for Scheduled vs Actual Employee Time and Wages 4
Time calculations for Scheduled vs Actual Employee Time and Wages 2
multiply total hours by hourly pay 3
why is answer rounded up? 1
Need to work hours backwards 10

Back
Top