The free guide

HOUR function

Use

HOUR function is used to extract an hour component between  0 (12:00 A.M.) to 23 (11:00 P.M.), from a given time. For example, from a time of 3:30 AM, you may extract an hour of 3 in a cell.

Syntax

HOUR(serial_number)

serial_number is a time format in Excel from which you want to extract an hour.

Example

Formula:

Results:

 

Copyright © 2016 - 2017 Explainry.com | All Rights Reserved