WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

The HOUR function in Excel

January 11, 2022
3.8K Views

·  Description:

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

·  Syntax:

HOUR(Serial_number)

·  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 returns7 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.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.