How to Use the SECOND Function in WPS on Windows

Use the SECOND function through 3 how-to topics, with 3 available without membership and 0 membership-related items; choose a topic from the index and follow the steps to enter or review the function.

How-to Index

How-to Guide

1. Enter the function through the Insert Function dialog

Entry point: Formulas tab → Insert Function

1. Select the cell where you want to enter the formula.
2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
3. Search for SECOND in the Insert Function dialog box.
4. Select the function and click OK.
5. Enter each parameter in the Function Arguments dialog box.
6. Click OK to finish entering the function.

Success Criteria

• The current cell contains the SECOND function.
• The full function expression is visible in the formula bar.
• The worksheet returns the seconds value from the selected time input.

Tips While Using

• Search with the standard function name SECOND.
• The parameter should be a recognizable time value or time serial number.
• If the result looks incorrect, check whether the source cell is stored as text instead of time.

2. Type the formula directly in a cell

Entry point: Cell → Formula bar

1. Select the cell where you want to enter the formula.
2. Type =SECOND(...) directly in the cell or in the formula bar.
3. Press Enter to confirm.
4. If you want to review the parameter prompt, type =SECOND( and then press F1.

Success Criteria

• The cell shows a calculated result instead of plain text.
• The formula bar keeps the =SECOND(...) structure.
• After you press Enter, the formula can be copied or filled to other cells.

Tips While Using

• The formula must start with an equals sign =.
• Use standard punctuation for parameter separation.
• When filling the formula across multiple cells, check whether relative or absolute references behave as expected.

3. Review the function syntax and parameter details

Entry point: Formulas tab → Insert Function

1. Click Insert Function on the Formulas tab.
2. Type SECOND in the search box.
3. Select the function and review the syntax SECOND(serial_number).
4. Click the help link for the function if you want more details.

Success Criteria

• You can see the function name and syntax structure for SECOND.
• You can confirm that the parameter name is serial_number.
• You are ready to return to the worksheet and enter the function correctly.

Tips While Using

• Syntax review is useful before formal entry when you want to confirm the parameter format.
• If the help content does not open, first check whether the current window is responding normally.
• Reviewing syntax does not change the worksheet until you return and enter the formula.