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.



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.


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