Date time functions in Excel

Excel supports you to process and calculate quickly with the functions that Excel provides such as calculation functions, date functions . one of them is the function of time to help you handle the prices. Time value: hour, minute, second most convenient way.

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

1. TIME function.

Syntax: TIME (hour, minute, second) .

Inside:

- 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.

Date time functions in Excel Picture 1

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: TIMEVALUE (time_text) .

Inside:

- 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: NOW () .

Date time functions in Excel Picture 2

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.

Date time functions in Excel Picture 3

4. Ham HOUR.

Syntax: HOUR (serial_number) .

Inside:

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

Date time functions in Excel Picture 4

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

5. MINUTE function

Syntax: MINUTE (serial_number) .

Inside:

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

Date time functions in Excel Picture 5

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

6. The SECOND function.

Syntax: SECOND (serial_number) .

Inside:

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

Date time functions in Excel Picture 6

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!