Add and subtract time
Total several positive and negative durations.
Add or subtract two duration quantities—not clock times—with automatic carry and borrowing.
The values represent amounts of time. Convert both to minutes, perform the operation, then normalize by dividing the total by 60.
3 h 45 min + 2 h 30 min = 6 h 15 min. The 75-minute subtotal carries one hour.
4 h 10 min − 1 h 45 min = 2 h 25 min. Borrowing one hour turns 10 minutes into 70 minutes.
Yes. They are normalized because these inputs are duration quantities.
It means the second duration is larger than the first in subtraction mode.
For several rows, use Add and Subtract Time. Learn about decimal hour conversion.
Total several positive and negative durations.
Add or subtract duration quantities with automatic carry and borrow.
Convert both ways and apply optional payroll-style rounding.