Tag Archives: google sheets help

HOUR function

Function Type: Date and Time Description: 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 beContinue reading “HOUR function”

YEAR function

Function Type: Date and Time Description: YEAR function in Excel or Google Sheets converts a serial number of a date to a day of the month.It returns an integer from 1990 to future years. You can use YEAR function to get the MONTH number from your TODAY function or NOW function which can be usedContinue reading “YEAR function”