View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default multiply total hours by hourly pay

If I25:I32 holds hours expressed in Excel units, you must multiply by 24:
=SUM(I25:I32)*24*I5

HTH
--
AP

"Bearacade" a écrit
dans le message de news:
...

That depends where the cell you have set up with the pay...

If I25:I32 is the hours, and let's say I5 is the hourly rate, you can
do:

=Sum(I25:I32)*I5


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile:
http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=554658