» Converting Text Representing Minutes and Seconds into Numerical Values
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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:
- PowerPoint® 2002 For Dummies®
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Special Edition Using Microsoft Excel 2002
No comments have been submitted.
