| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dividing a unit of time by a lump sum price
In a spreadsheet I am composing I have one column that has units of time
(such as :30, or 1:26) and then the next column I have the charges that occurred in that unit of time (sometimes the units of price are less than a penny i.e., 0.00015) I would like to divide the unit of time by the charges to come up with a charge per second average or in some cases exaxctly. How can I do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dividing a unit of time by a lump sum price
=B2/A2 would give you cost per second. You can either format to a desired
decimal place or use ROUND() to select the number of decimal places to which you'd like your Round. "sawahani" wrote: In a spreadsheet I am composing I have one column that has units of time (such as :30, or 1:26) and then the next column I have the charges that occurred in that unit of time (sometimes the units of price are less than a penny i.e., 0.00015) I would like to divide the unit of time by the charges to come up with a charge per second average or in some cases exaxctly. How can I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sales history and how Unit Price affects it... | Charts and Charting in Excel | |||
| how to enter negative amounts in the unit price column of excel | Excel Worksheet Functions | |||
| Populate cells with a unit price | Excel Discussion (Misc queries) | |||
| How do I enter a negative number in unit price column? | Excel Discussion (Misc queries) | |||
| How do you display negative numbers in the unit price column? | Excel Worksheet Functions | |||
Linear Mode
