MINUTE in WPS on Windows FAQ

When using MINUTE, the most common questions are about valid input values, the 0–59 return range, and nested formula usage; this FAQ includes 3 common questions and a 3-term glossary.

FAQ

What range does MINUTE return in WPS?

1. MINUTE returns the minute portion as an integer.
2. The return range is 0 to 59.
3. If the original value includes a full date and time, the function only extracts the minute part.

Why does MINUTE not return the result I expect?

1. Check whether the argument is a valid date or time value.
2. Check whether the field is empty or not suitable for time calculation.
3. If the formula is nested, check the parentheses and field references again.

How to use the MINUTE function in WPS on Windows with other formulas?

1. First, write MINUTE in a formula field and confirm that it returns the minute value by itself.
2. Then use that result as an argument or condition in another function.
3. Save the formula and confirm that the result updates when the original time field changes.

Glossary