How do I set up inches per Minute/Second in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to know how to take a known inch per Minute and divide by a known
measurement and displayed as minutes and seconds. The answer of the equation
(minutes and seconds) is where I'm having trouble.
 
Actually, you need to divide your measured length by the known rate (inches
per minute). This gives you the number of minutes, but to display using m:ss
format you need to divide by 1440, the number of minutes per day (since
Excel counts time as the fraction of a day).

So put your measurement in A2, your rate in B2, and this formula into C2:

=A2/B2/1440

Then format C2 using a custom number format of

m:ss

If you want fractional seconds, use m:ss.0, m:ss.00, or m:ss.000 (the most
you'll get is thousandths).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______
 

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

Similar Threads

Excel Excel calculate pay based on rate per minute 7
How to set scale of y axis for time 4
Converting Seconds to Hours, Minutes, Seconds 3
Does anyone know how to create a pace calculator (min/mile) in Exc 10
Excel Calculating Phone bill per second 6
Date/Time on X axis 3
How Do I Nail Down Chart Width for Printing 2
How do I average data per minute and per 10 minutes? 1

Back
Top