Cost Per Minute?

  • Thread starter Thread starter Frank Kabel
  • Start date Start date
F

Frank Kabel

Hi
if your time is in A1 and the value in A2 try
=A2/(A1*24*60)
and format this cell as number
 
If cell A1 = time and cell A2 = monetary value

=A2/(A1*1440) will give cost per minute

A1*1440 converts the time to a number of minutes. Times are stored as a
fraction of a day so you need to multiply by the number of minutes in a day.
You will need to change the format of the cell with the result in as it
is likely to default to a time format.

Tony
 
How do I obtain a cost per minute from, for example, 09:38:57 (hh:mm:ss)
where the monetary value is 14.7986 ?
 
Back
Top