create a formula to muliply hours times dollars per hour?

G

Guest

I need help to create formula to multiply hours worked times hourly rate to
get pay amount.
 
B

Biff

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
 

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

Work hours with overtime 2
Need to work hours backwards 10
multiply total hours by hourly pay 3
Formula assistance 10
wages - multiply hours and minutes by number of hours worked 6
Simple Time sheet, calculate OT 2
Calculate total for rate times hours in Excel? 3
simplify this formula 2

Top