Function Type: Date and Time


Converts a serial number to an hour.

Function Structure:


Argument Breakdown:

serial_number – A valid Excel time.


“HOUR” returns only the hour of the serial number, it ignores the minutes and seconds. Hours resets on 24-hour clock so if the serial number is more than 24 it will be like the serial number minus 24. As for decimal, it calculates the percentage of 24 and return the hour component.

If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig.

Back to Learn Excel->

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: