How to Use the SECOND Function in WPS on Windows

Last updated:July 23, 2026

Use the SECOND function in WPS with 3 how-to topics, all available without membership, and jump from the index to the steps you need.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and call SECONDFree
22. Check the parameter format of SECONDFree
33. Write and verify a sample SECOND formulaFree

How-to Guide

1. Create a formula field and call SECOND

Entry point: Add Field → Formula

  1. Open the table that you want to edit.
  2. Click Add Field.
  3. Select Formula as the field type.
  4. Enter a formula that includes SECOND in the formula editor.
  5. Click Confirm to save and check whether the result column appears.

Success Criteria

  • On-screen result: A new formula field appears in the table.
  • Next action available: You can continue editing the formula and review the calculated 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 edit permission for the current table.

2. Check the parameter format of SECOND

Entry point: Formula Editor → Function Library → SECOND

  1. Open the function library while editing a formula field.
  2. Find and select SECOND.
  3. Review the parameter format shown in the editor.
  4. Enter a time value or a related field as the argument.

Common format:

SECOND(time_value)

Success Criteria

  • On-screen result: You can see the function name and its parameter position.
  • Next action available: You can replace the argument with a field value or a time expression.

Tips While Using

  • Common mistake: If the argument is not a valid time value, the result may not return as expected.

3. Write and verify a sample SECOND formula

Entry point: Formula Editor

  1. Enter a sample formula in the formula field.
  2. For example, type SECOND(Time Field) or a combined expression with other functions.
  3. Save the formula and review the result column.
  4. Change the source time value and confirm that the result updates automatically.

Example:

SECOND(Time Field)

Success Criteria

  • On-screen result: The formula field shows a seconds result between 0 and 59.
  • Next action available: After you change the source field, the result refreshes automatically.

Tips While Using

  • Common mistake: Passing a non-time field directly may cause an unexpected result.
  • Environment note: If the source field is empty, review the result together with the actual data.