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.
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 () .
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: HOUR (serial_number) .
Inside:
- Serial_number is the time you want 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: MINUTE (serial_number) .
Inside:
- Serial_number: is the time you want 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: SECOND (serial_number) .
Inside:
- Serial_number: is the time you want 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!