View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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?