Excel Function : HOUR

Download now!

Excel Function : HOUR

Category

Date and time

Description

Converts a serial number to an hour

Microsoft Excel Reference Page

https://support.office.com/en-us/article/HOUR-function-a3afa879-86cb-4339-b1b5-2dd2d7310ac7

Syntax and Description of the HOUR Excel Function

=HOUR(A2)

About HOUR Excel Function

The HOUR function returns the hour of a time value. The hour is a number from 0 (12:00 AM) to 23 (11:00 PM).