HOUR function

1 comments-0 reblogs
avatar of @excelsheets
3 days ago - 1 minutes read

HOUR Function

Function Type:

Date and Time


HOUR function in Excel or Google Sheets is used to convert a serial number to an hour.

"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.

Function Structure: 



serial_number - a valid Excel time (serial number) or decimal number.


HOUR function examples

Still need help with Excel and Google Sheets?

Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.

Get Instant Expert Help on Fiverr

Get Instant Expert Help in PeoplePerHour

We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.

This post is designated as a reviewer for Excel trainings I conduct.

Feel free to share with anyone. 😉

Earnings from Upvotes on this post are used to continue sharing Excel knowledge. If you also want to earn HIVE in 7 days while blogging your favorite topics, join us here at Peakd.