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