HOUR in WPS on Windows: Introduction

WPS HOUR is a time extraction function used in multi-dimensional tables; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	3	Matches the number of rows in the How-to Index
Available without membership	3	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

The HOUR function in WPS multi-dimensional tables is used to extract the hour portion from a time value and return a result from 0 to 23.

Core tasks include:

Create a formula field and call HOUR to calculate hour values in records.
Enter parameters in the required function format.
View calculated results in the formula field and keep them updated with source data changes.

This function is useful for shift records, time-based summaries, event grouping, and hour-based data analysis in WPS Office on Windows.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	An internet connection is recommended for installation, sign-in, or sync; local formula editing does not require a constant connection
Other	You need access to a multi-dimensional table and permission to add fields and edit formulas

Source: System requirements for WPS Office

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, enter a multi-dimensional table, and confirm that you can access Add Field and Formula options

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	WPS multi-dimensional tables support using HOUR in a formula field to extract the hour from a time value, and the result can be used with other formulas.	Excel provides `HOUR(serial_number)` to return the hour of a time value as an integer from 0 to 23.	Google Sheets provides `HOUR(time)` to return the hour component of a specific time.	Notion formulas support `hour(date)` to return the hour from a date value, mainly in database property calculations.	Acrobat supports date and time fields and calculated values in PDF forms, but it does not provide a spreadsheet-style HOUR function.
WPS Advantages	Advantage: HOUR can be used directly in a formula field inside a multi-dimensional table. Distinct: results refresh with record data changes in the same table workflow.	Compared with WPS: Excel uses worksheet cell formulas and focuses on spreadsheet calculation workflows.	Compared with WPS: Google Sheets also supports hour extraction, mainly in online spreadsheet cells.	Compared with WPS: Notion supports hour extraction in database formulas, but the editing model is not a traditional spreadsheet function workflow.	Compared with WPS: Adobe focuses on PDF form fields and calculations rather than table-based hour extraction.
Official Source	—	Excel HOUR function	Google Sheets HOUR	Notion formula syntax	Acrobat form field properties

Overall Conclusion
If you need to extract hour values inside record-based table workflows, WPS provides a direct formula-field approach in multi-dimensional tables. Excel and Google Sheets remain strong options for classic spreadsheet formulas, while Notion and Adobe fit database and PDF form scenarios more closely.

Use Cases

No.	Use Case	Suitable For	Main Pain Point	How WPS Helps
1	Shift time breakdown	HR teams and admins	Need to extract hours from full time values quickly	Use HOUR to return the hour for grouping or counting
2	Peak-hour event analysis	Operations teams and data organizers	Need to review records by hour	Return hour values in a formula field for filtering or summaries
3	Imported data cleanup	Table maintainers	Raw time fields are not easy to analyze directly	Convert time values into comparable hour results
4	Auto-updating record display	Project collaborators	Need results to update when source data changes	Formula field results refresh with record updates
5	Combined formula logic	Advanced users	Need to combine hour values with other conditions	Use HOUR together with other functions

Membership & Benefits

Free vs WPS Premium

Capability	Free Users	WPS Premium
Core Writer, Spreadsheet, and Presentation apps	✅ Available	✅ Available
Basic use of HOUR in multi-dimensional tables	✅ Available	✅ Available
Some advanced PDF and extended tools	Limited	✅ More advanced features available
Cloud storage and added benefits	Basic allocation	Higher allocation and more added benefits

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
You mainly need HOUR and other basic formula features in multi-dimensional tables	Free	The feature information shows no membership restriction for this function
You also need more PDF tools, cloud storage, or added office benefits	WPS Premium	Better suited for users who need broader feature access

WPS membership center: Subscribe now