Cost Per Minute?

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
 
T

Tony

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
 
B

BT

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top