View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sawahani sawahani is offline
external usenet poster
 
Posts: 1
Default 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?