| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate total for rate times hours in Excel?
I have an excel 2003 worksheet that has the total number hours (hh:mm:ss) for
the week worked by an employee. I want to take that total and multiply it by that employee's hourly rate. I have tried the obvious of multiplying the cells but that doesn't work. -- Jenn |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate total for rate times hours in Excel?
Hi,
Convert the time to decimal by multiplying by 24 and then multiply by hourly rate. So with a time in A1 =A1*24*25 Where 25 is the hourly rate. Mike "whitjl143" wrote: I have an excel 2003 worksheet that has the total number hours (hh:mm:ss) for the week worked by an employee. I want to take that total and multiply it by that employee's hourly rate. I have tried the obvious of multiplying the cells but that doesn't work. -- Jenn |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate total for rate times hours in Excel?
I forgot that Excel will try and be helpful and format this as a time so
re-format as general Mike "Mike H" wrote: Hi, Convert the time to decimal by multiplying by 24 and then multiply by hourly rate. So with a time in A1 =A1*24*25 Where 25 is the hourly rate. Mike "whitjl143" wrote: I have an excel 2003 worksheet that has the total number hours (hh:mm:ss) for the week worked by an employee. I want to take that total and multiply it by that employee's hourly rate. I have tried the obvious of multiplying the cells but that doesn't work. -- Jenn |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate total for rate times hours in Excel?
Format the cell as Currency and multiply by 24.
whitjl143 wrote: I have an excel 2003 worksheet that has the total number hours (hh:mm:ss) for the week worked by an employee. I want to take that total and multiply it by that employee's hourly rate. I have tried the obvious of multiplying the cells but that doesn't work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate total pay from pay rate times hours and minutes | Excel Discussion (Misc queries) | |||
| How do I calculate total pay from [h]:mm times pay rate per hour? | Excel Worksheet Functions | |||
| Hourly rate times hours? | Excel Worksheet Functions | |||
| Calculation of hourly rate times hours times 1.5 | Excel Worksheet Functions | |||
| How do I calculate total hours by rate of pay? | Excel Worksheet Functions | |||
Hybrid Mode
