Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up inches per Minute/Second in Excel
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up inches per Minute/Second in Excel
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 _______ "Denise" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
any tips on working with feet and inches in excel? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
How can I show Feet and inches in a Excel cell? | Excel Discussion (Misc queries) |