To use this function, choose Calc > Calculator.

Returns the current date and time; for example, 12/5/2015 10:36:41 AM. This function is useful in macros and formulas.



If you store the result in a column, the output is in date/time format. You can display fractions of a second with the time by modifying the date/time format of 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 WHEN function to convert from the numeric representation to the date/time value.


A call center manager wants to determine how long technical support calls have gone unresolved. To determine the number of days elapsed since the initial call was received, the manager enters the expression NOW ()–C2 and stores the results in C3.

C2-D C3
Start time Time open (in days)
2/8/2016 9:15:41 1.94910
2/6/2016 10:21:36 3.90332
2/5/2016 8:45:03 4.97037
2/2/2016 11:11:54 7.86839
2/3/2016 2:10:30 7.24436
2/5/2016 16:09:03 4.66204
2/8/2016 15:17:36 1.69777
2/8/2016 12:30:37 1.81373
2/2/2016 8:31:06 7.98006
2/5/2016 9:10:49 4.95248
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy