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

D

Denise

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.
 
J

Jon Peltier

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

Calculate the median value before a specified list 0
How do I install Microsoft Equation 3.0 back to Office 365? 0
Converting Seconds to Hours, Minutes, Seconds 3
Access 2007,reports,VBA 2
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Round up or down to nearest 5, but not 10 2
How to set scale of y axis for time 5
Working on birthday "book" for my wife and having layout/editing trouble 0

Top