Dates & time
Duration adder
Add a list of times, including negative durations.
A clear answer. Here’s how.
Parses hours, minutes and optional seconds, then adds the signed durations. Hours may exceed 24. A leading minus sign applies to the whole duration. Minutes and seconds must be 00–59.
See a worked example
Worked example
A fixed demonstration, separate from the values you enter above.
- One H:MM or H:MM:SS duration per line
1:30 0:45 -0:15
Example result
- Total (H:MM:SS)
- 2:00:00
- Decimal hours
- 2
- Durations
- 3