When you use the MINUTE function in WPS on Windows, the most common questions are about syntax errors, function hints, and result checks; this FAQ covers 3 common questions.
FAQ
Why do I get a syntax error when entering the MINUTE function?
- Check whether the function name is spelled as
MINUTE. - Check whether the parentheses are complete.
- Check whether the argument is a valid time value, date-time value, or correct cell reference.
Why can’t I see the function hint when I type the formula?
- Make sure you are editing a formula in a cell instead of entering plain text.
- Type an equals sign first, then enter
MINUTE(. - If the hint still does not appear, select the cell again and re-enter the formula.
How to use the MINUTE function in WPS on Windows when the returned minute looks wrong?
- Check whether the source cell really contains a time or date-time value.
- Check whether the referenced cell is the correct one.
- Compare the result with the minute part of the original time value.
Glossary
| Term | Definition |
|---|---|
| MINUTE | A function that returns the minute part of a time value. |
| Time value | Data that a spreadsheet can recognize and use in time calculation. |
| Cell reference | A cell address such as A1 used in a formula to point to data. |