Function Type: Date and Time
Converts a serial number to an hour.
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.