Tuesday, November 5

HOUR Function To Extract Hour From Time

DEFINITION : Hour Function Returns The Hour From A Time As A Numeric Number Between 0-23. You Can Use The Hour Function To Extract The Hour As Output Into A Particular Cell.

SYNTAX:- =MINUTE (SERIAL_NUMBER) Serial number Must Be A Valid Time That Having A Valid Hours.

NOTE: To Extract The Hours For A Cell Having Hour Above or Equal To 24 You Must Have To Use Custom Format And Set It To [h]:mm

Leave a Reply

Your email address will not be published. Required fields are marked *