How to Use the MINUTE Function in WPS on Windows

Use the MINUTE function in WPS on Windows through 4 how-to topics, all available without membership; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Enter a basic MINUTE formula

Entry point: Open WPS Spreadsheet and select the target cell

1. Open the spreadsheet you want to edit.
2. Click an empty cell.
3. Type =MINUTE(A1), where A1 is the cell that contains the time value.
4. Press Enter to confirm the formula.

Success Criteria

• UI state: The cell returns an integer from 0 to 59.
• Next actions: You can copy the formula or change the referenced cell.

Tips While Using

• Common mistakes: Entering unrecognized text directly may cause an incorrect result.

2. Extract minutes from a date-time value

Entry point: Type the formula in the result cell

1. Confirm that the source cell contains both a date and time, such as 2026/7/20 14:35:10.
2. Type =MINUTE(A1) in the target cell.
3. Press Enter to view the returned result.

Success Criteria

• UI state: Even when the source cell contains both date and time, the result shows only the minute part.
• Next actions: You can use the result in sorting, filtering, or other formulas.

Tips While Using

• Common mistakes: If the time is stored as plain text instead of a recognized time value, the result may not match expectations.

3. View the function hint while typing

Entry point: Formula editing state in a cell or in the formula bar

1. Select an empty cell.
2. Type =MINUTE(.
3. Check the on-screen function name and parameter hint.
4. Complete the argument based on the hint and finish the formula.

Success Criteria

• UI state: A function hint appears after you type the function name.
• Next actions: You can continue entering the argument and complete the formula.

Tips While Using

• Common mistakes: An unclosed parenthesis or an incorrect argument position can trigger a syntax error.

4. Check whether the result is correct

Entry point: The cell that displays the formula result

1. Compare the result with the minute part of the original time value.
2. Check whether the formula references the correct cell.
3. Confirm that the input is a recognized time or date-time value.
4. If the result does not match, adjust the source data or the formula and calculate again.

Success Criteria

• UI state: The result matches the minute part of the original time value.
• Next actions: You can fill the formula down to other rows.

Tips While Using

• Common mistakes: The formula may point to the wrong cell, or the source data may not be a valid time value.