Elapsed time function

To use this function, choose Calc > Calculator.

Returns the time that has elapsed between two date/time values. This function is useful in macros and formulas.

Syntax

ELAPSED(number)

For number, enter the column with the end times minus the column with the start times. The columns must be in date/time format.

The elapsed time is specified in minutes and seconds (mm:ss) if the maximum value of the output column is less than one hour; the elapsed time is specified in hours, minutes, and seconds (hh:mm:ss) if the maximum of the output column is an hour or more.

Example

A call center manager wants to determine the length of phone calls. To determine the duration of each phone call in hours, minutes, and seconds, the manager enters the expression ELAPSED (C3–C2) and stores the results in C3.

C2-D	C3-D	C4-D
Call received	Call completed	Duration of call
11/29/2015 4:27PM	11/29/2015 4:55PM	28:00
11/29/2015 4:33PM	11/29/2015 4:41PM	8:00
11/29/2015 4:45PM	11/29/2015 4:46PM	1:00
11/29/2015 4:48PM	11/29/2015 5:02PM	14:00
11/30/2015 8:11AM	11/30/2015 8:17AM	1:06:00
11/30/2015 8:30AM	11/30/2015 8:44AM	14:00
11/30/2015 8:54AM	11/30/2015 9:17AM	23:00
11/30/2015 9:02AM	11/30/2015 9:03AM	1:00