SECOND in WPS on Windows FAQ

Last updated:July 23, 2026

When using SECOND in WPS, the most common questions focus on parameter format, unexpected results, and combined formulas. This FAQ covers 3 frequent questions.

FAQ

What should I check if the SECOND function returns an error?

  1. Check whether the argument is a valid time value or a recognizable time field.
  2. Confirm that the formula is complete, including parentheses and field references.
  3. If another field is referenced, verify that the original data format in that field is correct.

Can SECOND be used with other functions?

  1. Use SECOND to extract the seconds value first.
  2. Then use that result as a condition or calculation input in functions such as IF.
  3. Save the formula and confirm that the combined result matches your expectation.

Does the SECOND result update automatically after I change the source time?

  1. Formula fields usually recalculate when the source field changes.
  2. After you edit the time field, the returned result should update as well.
  3. If it does not change, review the field reference and the formula content again.

Glossary

TermDefinition
SECONDA function that extracts the seconds part of a time value and returns an integer from 0 to 59.
Formula fieldA field type in WPS tables that calculates results automatically from a formula.
Time valueTime data that the function can recognize and use for extracting hours, minutes, or seconds.