HOUR
Gives the hour information of the specified time
Gives the hour information of the specified time
Syntax of Excel Hour formula:
=HOUR(serian_number)
In words:
=Fetch only hours(from this time)
=HOUR(NOW())
Gives the hours currently on computer’s clock.
=HOUR(H7) will give only the hours from the time mentioned in cell H7