The HOUR function in Excel

January 11, 2022
649 Views 0

·  Description:

HOUR function returns the hour as number from 0 (12:00 AM) to 23 (11:00 P.M).

·  Syntax:


·  Arguments:

Serial_number: A number in the date -time code used by WPS spreadsheets, or text in time format.

·  Example:

Suppose we have the employees' clock-in time and want to return their entry hour. What can we do with the help of the HOUR function?

1. Open your table with WPS Spreadsheets.

2. Select cell C3 where we want to calculate the entry hour of Mike. We want to insert the HOUR function here.

HOUR function returns the hour as a number. In this case, it returns 7 because the integer of the value in cell A2 is 7.

So, we enter B3 at Serial_number and get the result 7. Then, hover over cell C3 and drag it all the way down.

 hour function in Excel.gif

Was this helpful?