» 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:
- Microsoft Access 2002 for Dummies
- Financial Modeling - 2nd Edition
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
No comments have been submitted.
