How to Use the HOUR Function in WPS on Windows

Last updated:July 23, 2026

This how-to guide includes 3 topics for using HOUR, with 3 free topics and 0 membership-related topics; choose a topic from the index and follow the steps.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and use HOURFree
22. Check the parameter formatFree
33. Use HOUR with an exampleFree

How-to Guide

1. Create a formula field and use HOUR

Entry: Add Field → Formula

  1. Click Add Field on the toolbar.
  2. Select the Formula field type.
  3. Enter a formula that includes HOUR in the editor.
  4. Fill in a time value or a field reference as needed.
  5. Click Confirm to save and view the result.

Success Criteria

  • Interface result: A new formula field appears in the table.
  • What you can do next: The field shows the calculated HOUR result.

Tips While Using

  • Common mistake: If you do not choose the Formula field type, you cannot enter the function correctly.
  • Environment note: You need permission to edit the current multi-dimensional table.

2. Check the parameter format

Entry: Formula editor → Function library → HOUR

  1. Open the formula editor.
  2. Find HOUR in the function library.
  3. Review the function format and parameter position.
  4. Enter the parameter based on your actual data.

A common format is:

HOUR(time_value)

You can pass a reference, a date-time value, or an expression that returns a date-time result.

Success Criteria

  • Interface result: You can see the HOUR format in the editor.
  • What you can do next: You can enter the formula in the correct format and save it.

Tips While Using

  • Common mistake: If the parameter is not a valid time value, the result may not match your expectation.
  • Environment note: Check whether the source field format can be used for time calculation.

3. Use HOUR with an example

Entry: Formula field editor

  1. Create or select a formula field.
  2. Enter an example formula such as HOUR(Time Field).
  3. Click Confirm to save the formula.
  4. Review the returned hour result for each record.
  5. Continue combining it with other functions if needed.

Success Criteria

  • Interface result: Records display hour values from 0 to 23.
  • What you can do next: You can use the result for filtering, grouping, or combined calculations.

Tips While Using

  • Common mistake: Entering text in an invalid format may cause unexpected results.
  • Environment note: If the source field is empty, the displayed result changes with the source data state.