» Converting Text Representing Minutes and Seconds into Numerical Values
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Problem: Column A contains text strings representing time values in the "Xm Ys" format.
X represents the number of minutes and Y represents the number of seconds.
We want to calculate the total number of seconds represented by each string in column A.
Solution:
Use the LEFT, FIND, LEN, and MID functions as shown in the following formula:
=(LEFT(A2,FIND("m",A2)-1)*60)+LEFT(MID(A2,FIND(" ",A2)+1,99),LEN(MID(A2,FIND(" ",A2)+1,99))-1)
Book Store:
Recommended Books:
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- The Fall of Advertising and the Rise of PR
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Windows XP All-in-One Desk Reference For Dummies
No comments have been submitted.
