| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Product of Hrs & minutes times rate per hr to give a cost
I have formatted a cell in hr:mm:ss and have a number in another cell and
have inserted a formula in a third cell to multiply cells 1 and 2 together but I am not getting the correct answer. Presumably I need to format one or all of these cells differently. Please help!!! -- Steve Tupper |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Product of Hrs & minutes times rate per hr to give a cost
If your hr:mm:ss really is a number formatted as a time, then you probably
just need to multiply your result by 24 and format the result as currency. The reason for multiplying by 24 that 1 represents a day, so an hour is 1/24, but you need to get the number of hours. "Steve" wrote: I have formatted a cell in hr:mm:ss and have a number in another cell and have inserted a formula in a third cell to multiply cells 1 and 2 together but I am not getting the correct answer. Presumably I need to format one or all of these cells differently. Please help!!! -- Steve Tupper |
| 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) | |||
| Calculating cost of product | Excel Worksheet Functions | |||
| How do I calculate cost of raw materials to final product? | Excel Discussion (Misc queries) | |||
| ENTER PRODUCT # AND HAVE assign DESC. & COST in invoice | New Users to Excel | |||
| Calculation of hourly rate times hours times 1.5 | Excel Worksheet Functions | |||
![Steve[_14_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
