16. Excel How to add times ?

In Excel, dates and times are stored and processed as numbers. To add one time to another, simply use the addition operator.

In the following example, the duration of the journey is added to the start time to find the finish time:

Excel 2016 Example Add Times

Conversely, to calculate the duration between two times, the subtraction operator must be used:

Arrival_time - Departure_time

<< 15. Excel How to add columns ?

17. Excel How to break links ? >>

Reader comments

Add a comment