© Mandeep Mehta 2021
M. MehtaMicrosoft Excel Functions Quick Referencehttps://doi.org/10.1007/978-1-4842-6613-7_4

4. Time Functions

Mandeep Mehta1  
(1)
Mumbai, India
 

In this chapter, we will look at some of the commonly used time functions provided by Excel.

Note

In the time functions in this chapter, the argument time can be

  • a literal date-time value,

  • an Excel function returning a date-time,

  • a cell reference where the cell contains a date-time, or

  • a named range containing a date-time value.

Let us begin exploring the most commonly used time functions.

NOW Function

The NOW function returns the system date and time at the point this function is executed.

Syntax

=NOW()

The NOW function does not take any argument.

Example

Figure 4-1 shows an example of the NOW ...

Get Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.