Current time function

To use this function, choose Calc > Calculator.

Returns the current time; for example, 9:26:20 AM. This function is useful in macros and formulas. The Current Time function is often used in conjunction with the Elapsed Time function to calculate elapsed time in hours, minutes, and seconds.



If you store the result in a column, the output is in date/time format. You can display fractions of a second by specifying the appropriate date/time format for the column. If you store the result in a constant, the output is the numeric representation of the date/time value. You can use the Time function to convert from the numeric representation to the time value.


A service manager wants to determine how long a service call has been open. He enters the expression ELAPSED(CTIME () – C2) and stores the results in C3.

C2-D C3-D
Service request Time open
7:15:41 AM 2:46:48
7:21:36 AM 2:40:53
7:45:03 AM 2:17:26
8:11:54 AM 1:50:35
8:20:30 AM 1:41:59
8:39:03 AM 1:23:26
9:17:36 AM 0:44:53
9:31:37 AM 0:30:52
9:42:06 AM 0:20:23
9:50:49 AM 0:11:40
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy