How to Use the SECOND Function in WPS on Windows

Last updated:July 20, 2026

Use the SECOND function with 3 how-to topics, including entering the function, checking syntax prompts, and validating results; choose a topic from the index and follow the entry path and steps.

How-to Index

No.TopicMembership Requirement
11. Enter the SECOND functionFree
22. Check the function syntax promptFree
33. Validate and reuse the resultFree

How-to Guide

1. Enter the SECOND function

Entry path: Formulas tab → formula bar

  1. Open WPS Spreadsheet and select the cell where you want the formula.
  2. Type = in the cell or formula bar.
  3. Type SECOND(.
  4. Enter the time value or cell reference that contains the time.
  5. Type the closing parenthesis and press Enter.

Success Criteria

  • On-screen result: The target cell shows the seconds value.
  • Next action available: You can continue editing, copying, or filling the formula down.

Tips While Using

  • Common mistake: Missing parentheses or an invalid argument can prevent the formula from returning a result.
  • Environment note: The input should be a recognizable time value or a valid reference used in time calculation.

2. Check the function syntax prompt

Entry path: formula bar

  1. Select a target cell and type =SECOND(.
  2. Watch for the syntax prompt in the editing area.
  3. Confirm the argument format shown in the prompt.
  4. Finish the formula and press Enter.

Success Criteria

  • On-screen result: A function prompt appears while you type.
  • Next action available: You can complete the argument based on the prompt and finish the calculation.

Tips While Using

  • Common mistake: If you do not type the opening parenthesis, the prompt may not expand for the current function.

3. Validate and reuse the result

Entry path: result cell with an existing SECOND formula

  1. Check whether the returned seconds match the original time value.
  2. Fill the formula down if you need to process more rows.
  3. Change the source time value and confirm that the result updates.
  4. Use the returned seconds in later formulas or checks.

Success Criteria

  • On-screen result: Other cells in the same column can return the corresponding seconds values.
  • Next action available: The result can be used in later formulas.
  • No side effect: Extracting seconds does not overwrite the original time data.

Tips While Using

  • Common mistake: If you copy the formula without checking references, the result may point to the wrong source cell.