HOUR function - The function returns the hour of a time value in Excel

The following article introduces you to the HOUR function - one of the functions in the date and time group is very popular in Excel.

HOUR function - The function returns the hour of a time value in Excel Picture 1

Description: The function returns the hour value of a time value, the hour is returned as an integer.

Syntax : HOUR (serial_number)

Where: serial_number is the time value want to count, is a required parameter.

Attention:

- Where serial_number value is a date value does not specify the time the function will return the value #VALUE !.

- The time value is part of the date value and it is expressed as a decimal.

For example:

Calculate the hour value in the time value in the following table:

HOUR function - The function returns the hour of a time value in Excel Picture 2

- In the cell to calculate enter the formula : = HOUR (E7).

HOUR function - The function returns the hour of a time value in Excel Picture 3

- Press Enter -> 25% of 24 hours is:

HOUR function - The function returns the hour of a time value in Excel Picture 4

- Similarly copying the formula for the remaining values results:

HOUR function - The function returns the hour of a time value in Excel Picture 5

- Where the value seri_number does not contain the hour unit -> the function returns the #VALUE! Error value

HOUR function - The function returns the hour of a time value in Excel Picture 6

Above are instructions and some specific examples in working with HOUR function in Excel.

Good luck!

Lesley Montoya

Update 19 May 2020

You should read it

May be interested

F.TEST function - The function returns the result of the F - test in Excel
f.test: the function returns the result of the f - test, the probability of two ends where the variance of 2 arrays is not significant. support functions from excel 2010 version. syntax: f.test (array1, array2)
DAYS function, how to use the function to calculate the number of days between two time points in Excel
the days function in excel returns the results between two different timelines.
GAMMA function - The function returns the gamma function value in Excel
gamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)
WEIBULL function - The function returns the Weibull distribution in Excel
the function performs the calculation and returns the weibull distribution. based on this distribution to analyze reliability in theory such as calculating the average life of the device or used in the field of meteorology, hydrology and weather forecast.
QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excel
quartile.exc function: the function returns the quartile of the data set, with percentile values from 0 to 1 excluding 0 and 1. the support function is from excel 2010 onwards. syntax: quartile.exc (array, quart)
DATEPART function in SQL Server
the datepart function in sql server returns a time value of the input argument, which can be day, month, year, quarter, hour, minute, second, millisecond ... the return value is an integer type (int)
TIMEVALUE function - The function returns the decimal number of time expressed as a text string in Excel
timevalue function: the function returns the decimal number of time indicated by a text string. the decimal number that the function returns is from 0 to 0.99988426, which corresponds to the time from 0:00:00 (12:00:00 am) to 23:59:59 (11:59:59 pm). syntax: timevalue (time_text)
MINVERSE function - The function returns the inverse matrix of a given matrix in Excel
calculating the inverse matrix of a given matrix is very confusing and manual calculations take a lot of time. the following article shows how to use the minverse function in excel, which returns the inverse matrix of a given matrix.
PHI function - The function returns the value of the density function for a normal distribution in Excel
phi function: the function returns the value of the density function for a standard normal distribution. support functions from excel 2013 onwards. syntax: phi (x)
FORECAST function - The function returns a value along a linear trend in Excel
forecast function: the function performs the calculation or prediction of a future value by using current values using linear regression. in excel 2016 this function is replaced by forecast.linear function. syntax: forecast (x, known_ys, known_xs)

HOUR function - The function returns the hour of a time value in Excel

You should read it

May be interested

Office information