MINUTE in WPS on Windows FAQ

Last updated:July 17, 2026

When using the MINUTE function in WPS Spreadsheet, common questions usually involve input format, incorrect results, function hints, and references; this FAQ includes 4 common questions and 4 glossary terms.

FAQ

What should I do if the MINUTE function shows an error after I enter it?

  1. Check whether the formula starts with =.
  2. Check whether the parentheses are paired correctly.
  3. Make sure the argument is a valid time, date-time value, or recognized cell reference.
  4. Press Enter again to confirm the formula.

Why is the MINUTE result incorrect?

  1. Check whether the referenced cell contains a time or date-time value.
  2. Make sure the cell does not contain only plain text.
  3. If you use nested formulas, review each returned value step by step.
  4. Change the source data and check whether the result updates.

How can I view the argument hint for the MINUTE function?

  1. Select the target cell and type =.
  2. Type MINUTE(.
  3. Check whether the syntax hint appears in the formula editing area.
  4. If it does not appear, enter edit mode again and retry.

Can MINUTE be used with other formulas?

  1. Yes. First enter MINUTE by itself and confirm that the result is correct.
  2. Then place it inside another formula for a combined calculation.
  3. Check the parenthesis levels and argument order after nesting.
  4. After that, change the source data to verify the linked result.

Glossary

TermDefinition
MINUTEA function that returns the minute portion of a time value, usually as an integer from 0 to 59.
ArgumentThe input inside a function’s parentheses, such as a time value, a date-time value, or a cell reference.
Cell referenceA cell address used as formula input, such as A2, B5, or a cross-sheet reference.
Automatic recalculationA behavior in which the formula result updates automatically when the source data changes.