WPS Features
Resources
Free AI Tools
Docs Center

How to Use the MINUTE Function in WPS on Windows

Last updated:July 13, 2026

This section covers 3 how-to topics for the MINUTE function, with 3 free topics and 0 membership-related topics; use the index below to jump to the task you need.

How-to Index

No.TopicMembership
11. Insert MINUTE from the Insert Function dialogFree
22. Type the formula directly in a cellFree
33. Review syntax and parameter guidanceFree

How-to Guide

1. Insert MINUTE from the Insert Function dialog

Entry point: Formula tab → Insert Function

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formula tab.
  3. Search for MINUTE in the dialog box.
  4. Select the function and click OK.
  5. Enter the required parameter in the Function Arguments dialog.
  6. Click OK to finish inserting the function.

Success Criteria

  • The selected cell now contains the MINUTE function.
  • After the parameter is entered, the cell returns a minute value.
  • The formula can be edited, copied, or filled down.

Tips While Using

  • The parameter should be a valid time value, date-time value, or a result that WPS can recognize as time-related data.
  • If the result looks wrong, check whether the source cell is stored as text.

2. Type the formula directly in a cell

Entry point: Cell → Formula bar

  1. Select the target cell.
  2. Type =MINUTE(...) in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If needed, drag the fill handle to copy the formula to other cells.

Success Criteria

  • The cell displays the result of the MINUTE formula.
  • The formula calculates after you press Enter.
  • Copied cells return the corresponding minute values.

Tips While Using

  • Use standard formula punctuation and separators.
  • When filling the formula across rows, check whether relative or absolute references are appropriate.

3. Review syntax and parameter guidance

Entry point: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Search for MINUTE.
  3. Select the function and review the syntax MINUTE(serial_number).
  4. Open the available help entry to review parameter guidance and usage notes.

Success Criteria

  • You can see the MINUTE function name and syntax structure.
  • You can confirm the parameter name serial_number and its expected input.
  • You can return to the worksheet and continue entering the formula.

Tips While Using

  • Reviewing syntax first can help reduce input errors.
  • If the result does not match your expectation, return here and check the parameter format again.