Working with Worksheet Functions

Close Window 

Calculating Elapsed Time

To calculate elapsed time, subtract an earlier time from a later one, like so:

  1. In one cell cell A1, or wherever enter one time, using am/pm or 24-hour clock notation.

  2. In another cell cell A2, or wherever enter another, later, time, again using am/pm or 24-hour clock notation.

  3. In a third cell, enter a formula that subtracts the earlier time from the later time in our example:

=A2-A1

  1. Press Enter.

  2. Right-click the cell containing the formula and select Format Cells from the shortcut menu.

  3. In the Format Cells dialog box, click the Number tab.

  4. In the Category list, pick Custom.

  5. In the Type text box, type

[h]:mm

  1. Click OK.

(Posted 6/9/2000)