ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   create a formula to muliply hours times dollars per hour? (https://www.excelbanter.com/excel-discussion-misc-queries/109885-create-formula-muliply-hours-times-dollars-per-hour.html)

sirrafs

create a formula to muliply hours times dollars per hour?
 
I need help to create formula to multiply hours worked times hourly rate to
get pay amount.

Biff

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.





All times are GMT +1. The time now is 07:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com