HOUR

Gives the hour information of the specified time

Syntax of Excel Hour formula:
=HOUR(serian_number)

In words:
=Fetch only hours(from this time)

Examples of Excel Hour formula

=HOUR(NOW())
Gives the hours currently on computer’s clock.

=HOUR(H7) will give only the hours from the time mentioned in cell H7