To use this function, choose .
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.
|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|