Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I create formula to sum hours & min's Susan Excel Worksheet Functions 4 August 22nd 06 11:26 PM
Help with Sum if (or something else not sure) Lost in reconcillation Excel Worksheet Functions 5 June 6th 06 08:57 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
How to create specific formula STS Excel Worksheet Functions 4 May 2nd 05 01:44 AM


All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"