» 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 an IF statement to determine which of the two values is the "earliest", and then subtract accordingly:
=B2-A2+IF(A2>B2,1)
Example:
Time1___Time2____Result
10:00___17:00____7:00
17:00___9:00_____16:00
12:00___15:00____3:00
Book Store:
Recommended Books:
- Windows XP Annoyances
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Financial Reporting and Analysis (2nd Edition)
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Special Edition Using Microsoft Word 2002
subtracting times
neilmacm
Hope this helps with your problem.
=G10-F10+IF(F10>G10,24)
Calculation of total working times
Nam
Hi,
I have a problem when I do sums of hours for whole month. The number goes beyond 12 hours. What have I to do to have total number of working hours (biger number than 12). Thanks
292
THIS IS GREAT, BUT NOW HOW DO I GET THE TOTAL HOURS FOR ONE WEEK? THE =SUM THING DOES NOT WORK (SORRY, JUST LEARNING ALL THIS...)
time
problem
hi...m trying to calculate flight times....
i have departing time from one city and i have to calculate the arrival time in another city....which means i have to take time zone difference in account...thanx a bunch
The formula does work well. However, if i have a situation of start time at 19:00pm and end time at 1:00am (past midnight). The result should be 6 hr but it return a value of 17. is there any formula to accommodate this?