Date Time Functions in Excel

This article provides a clear overview of Date Time Functions in Excel, with the main facts, useful context, and practical details organized for easy reading.

The article introduces the syntax and use of time functions in Excel.

1. TIME Function.

Syntax

Syntax: TIME (hour, minute, second) .

Arguments

- TIME: function name.

- Hour: hour value.

- Minute: minute value.

- Second: value seconds.

Hour, minute, second are a number from 0 to 32767 and are all required parameters.

Function: The function returns a decimal number of a specific time value between 0 and less than 1. If the cell's format is General before the function is entered, the return function will be expressed in hours and minutes seconds.

2. TIMEVALUE Function

Syntax

Syntax: TIMEVALUE (time_text) .

Arguments

- Time_text: a text string representing the time value and a required parameter.

Function: The function returns a decimal number of a specific time value that ranges from 0 to less than 1 as expressed by Time_text.

3. NOW Function.

Syntax

Syntax: NOW () .

Function: The NOW () function returns the current system date, time and minute (the format of the cell before entering the function is General).

If the syntax NOW () - 1 is entered, the function will return the date, time and minute, one day less than the current system date and time.

4. Ham HOUR.

Syntax

Syntax: HOUR (serial_number) .

Arguments

- Serial_number is the time you may need to convert to hours, is a required parameter.

Function: Returns the hour of a time value, the result is an integer between 0 and 23.

5. MINUTE Function

Syntax

Syntax: MINUTE (serial_number) .

Arguments

- Serial_number: is the time you may need to convert to minutes, is a required parameter.

Function: Returns the minute portion of the time value, the result is an integer between 0 and 59.

6. the SECOND Function.

Syntax

Syntax: SECOND (serial_number) .

Arguments

- Serial_number: is the time you may need to convert into seconds, is a required parameter.

Function: Returns the second part of the time value, the result is an integer between 0 and 59.

Each time function is a function that has its own uses, depending on the needs and purposes of your work, study that you use the most appropriate time function. Good luck!