» Subtracting Times
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Finding the interval between each pair of start and end times in columns A & B. An error occurs when the end time is "earlier" than the start time, resulting in a negative result.
Solution:
Use the IF function as shown in the following formula to determine which of the two values is the "earliest", and then subtract accordingly:
=B2-A2+IF(A2>B2,1)
Book Store:
Recommended Books:
- Keys to Reading an Annual Report (Barron's Business Keys)
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Definitive Guide to Excel VBA
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- The Analysis and Use of Financial Statements
- Business Plans For Dummies®
calculating time in ms excel
bhalchandra2000
how to calculate time in excel from yesterdays 13:15:00 to tadays 11:25:00.
