» 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:
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Keys to Reading an Annual Report (Barron's Business Keys)
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Microsoft Excel 2002 Formulas (With CD-ROM)
No comments have been submitted.
