# HOUR

## Rational

Find hour component from a time value.

## Description

The Excel HOUR function returns the hour component of a time value or timestamp between 0 (12:00 A.M.) and 23 (11:59 P.M.). Example; to find hours from the proportion of a day, use =HOUR(0.3) that returns ‘7’ (0.3*24).

Extracting the hour component of a specified time is useful in finding specific hourly event of a date.

## Syntax

=HOUR(serial_number)

## Parameters

serial_number – A time value

## Return Value

An integer representing Hour component

## Key Notes

• Excel HOUR function is used to extract an hour from a specified date or serial number. Enter date with Colon (:) like 12:00.
• In case of time value display AM/PM, the return value will be between 0 to 23, like 2:00 PM return 14 where 2:00 AM return 2.
• The Hour function return value in case of argument is integer or decimal. Like 0.6 return value of 0.6*24 = 14, not 14.4 whereas 0.5 return a value of 12 representing the hour component of time value in terms a day.
• Use SECOND and MINUTE functions to return other two components of Timestamp.

### MINUTE

The MINUTE function returns the minute component of a time value. For example, with a time of 6:48 PM or text, =MINUTE(time) will return ’48’.

### TIME

The TIME function returns the time value by merging the three-time components. Example, use =TIME(9,15,35), that may returns “09:15:35”.

### NOW

The NOW function returns the serial number of the current date and time. Example; to show the current date and time, use NOW(), empty parenthesis.

### SECOND

The SECOND function returns the second component (a number from 0 to 59). Example, 6:48:15 PM, the SECOND function will return ‘15’.

### DAY

The DAY function returns an integer value that represents the day element of a date. I.e.; to extract day component, use =DAY(“08-08-2017”) that returns ‘8’.