Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Amount to be Paid
I am sure this is a simple formula, but for the life of me I cannot figure
this one out at the moment. I have a column oshowing the number of hours worked (formatted [h):mm ) and need to caluclate if paid $50.00 per hour how much would that individual be paid for the number of hours worked? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Amount to be Paid
Try this:
=time*24*rate A1 = 8:00 B1 = 50 =A1*24*B1 Format as General or Number -- Biff Microsoft Excel MVP "Jennifer" wrote in message ... I am sure this is a simple formula, but for the life of me I cannot figure this one out at the moment. I have a column oshowing the number of hours worked (formatted [h):mm ) and need to caluclate if paid $50.00 per hour how much would that individual be paid for the number of hours worked? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Amount to be Paid
=Time*24*Rate Times are stored in Excel as fractions of a 24-hour day (0.25 = 6:00, 0.5 = 12:00, 0.75 = 18:00 and so on), so multiplying a time value by 24 gives you the number of hours. Multiply that by the $/hr rate and you'll have the desired result. I have a lot of formulas and code related to dates and times in Excel at http://www.cpearson.com/Excel/datetime.htm Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Wed, 19 Nov 2008 12:54:33 -0800, Jennifer wrote: I am sure this is a simple formula, but for the life of me I cannot figure this one out at the moment. I have a column oshowing the number of hours worked (formatted [h):mm ) and need to caluclate if paid $50.00 per hour how much would that individual be paid for the number of hours worked? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Paid and unpaid bills. | Excel Worksheet Functions | |||
Calculating Interest Amount | Excel Worksheet Functions | |||
Calculating a aariable amount or row | Excel Discussion (Misc queries) | |||
Formula for amount owing subtract amount paid | Excel Worksheet Functions | |||
Trying to sum the amount of principal paid for X number of paymen. | Excel Worksheet Functions |