| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiply total hours by hourly pay
I'm trying to figure out what the formula is to multiply the total hours worked per week by their hourly pay for each individual. kind of like the =Sum(I25:I32) Formula but I want to multiply the outcome of that formula by the hourly rate of 11.00, 15.00 and 16.00. Does anybody know how this can be done? If so I would greatly appreciate it. Thanks! charitydc -- charitydc ------------------------------------------------------------------------ charitydc's Profile: http://www.excelforum.com/member.php...o&userid=35682 View this thread: http://www.excelforum.com/showthread...hreadid=554658 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiply total hours by hourly pay
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiply total hours by hourly pay
Thank you BearAcade..... that's exactly what I was looking for! Thanks guys for the super fast help! charitydc -- charitydc ------------------------------------------------------------------------ charitydc's Profile: http://www.excelforum.com/member.php...o&userid=35682 View this thread: http://www.excelforum.com/showthread...hreadid=554658 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get total hours from 2 date/time cells? | Excel Discussion (Misc queries) | |||
| Calculating Business Hours Between 2 Dates | Excel Discussion (Misc queries) | |||
| Sum minutes and seconds to total hours | Excel Discussion (Misc queries) | |||
| scheduled hours total | Excel Worksheet Functions | |||
| Problems calculating total hours | Excel Discussion (Misc queries) | |||
Linear Mode
