MINUTE in WPS on Windows: Introduction

MINUTE in WPS Spreadsheet on Windows is a date and time function used to return the minute portion of a time value; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

MINUTE is a built-in function in WPS Spreadsheet for Windows. It returns the minute number from a time or date-time value and is useful for attendance tracking, time splitting, log analysis, and linked formulas.

Core capabilities include:

Extracting minute values: returns the minute portion from a time or date-time value, from 0 to 59.
Working with other formulas: can be combined with time or logic formulas.
Supporting cross-sheet references: can use time values from other cells or worksheets.
Recalculating automatically: updates the result when the source value changes.

System Requirements

Item	Requirement
Operating system	A Windows device that can run the current version of WPS Office
App version	The latest version of WPS Office is recommended
Network	No required network connection for local formula calculation; internet access is needed for download, sign-in, or sync
Other	You need to open WPS Spreadsheet files and have permission to edit formulas in cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation notes	Download and install WPS Office for Windows, then open WPS Spreadsheet to use formula features
Check after installation	Start WPS Spreadsheet and confirm that you can type `=MINUTE(` in a cell and see function hints

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Spreadsheet, `MINUTE(time)` returns the minute portion of a time value and supports cell references, nested calculations, and automatic updates.	Microsoft provides the `Minute(time)` function, which returns a whole number from 0 to 59 for the minute portion of a time value.	Google Sheets provides `MINUTE(time)` to return the minute component of a specific time and supports references, numeric time values, and related time functions.	Notion formulas support `minute()` to return the minute of a date value from 0 to 59 in database calculations.	Adobe Acrobat provides date and time fields plus calculated values in PDF forms, which supports form workflows rather than spreadsheet cell formulas.
WPS Advantages	Advantage: Works directly in spreadsheet cells for minute extraction and linked calculations; Distinct: fits table analysis, cross-sheet references, and automatic recalculation in one worksheet workflow.	Compared with WPS: also supports minute extraction, but the cited page describes a VBA function that is more script-oriented than a standard spreadsheet formula help page.	Compared with WPS: the formula behavior is similar; WPS is more aligned with a local desktop spreadsheet workflow.	Compared with WPS: can return minute values from date properties, but it is designed for database formulas rather than a traditional spreadsheet grid.	Compared with WPS: focuses on PDF form fields and calculations, not spreadsheet-style cell formulas for tabular analysis.
Official Source	—	Minute function	MINUTE	Formula syntax and functions	PDF form fields

Overall Conclusion
WPS MINUTE is well suited to direct time splitting and linked calculations in spreadsheets. If your work centers on table analysis, cell references, and automatic recalculation, WPS provides a workflow that fits everyday spreadsheet editing, while the other products focus more on scripting, online sheets, database formulas, or PDF forms.

Use Cases

No.	Scenario	Suitable Users	Core Need	How It Helps
1	Attendance time splitting	HR and admin staff	Quickly extract minute values from check-in times	Use MINUTE in a cell to return the minute portion
2	Log time analysis	Data coordinators	Review records by minute-level time values	Combine MINUTE with summary formulas
3	Cross-sheet time references	Finance and operations teams	Calculate time values across multiple sheets	Reference time cells from another worksheet and use MINUTE
4	Linked formula models	Advanced spreadsheet users	Update results automatically when time fields change	Use MINUTE with other formulas for recalculation
5	Teaching and practice	Students and trainers	Demonstrate basic time function behavior	Show sample formulas for minute extraction

Membership & Benefits

These 3 membership topics help you compare free use and broader office benefits; the MINUTE function itself is available without membership.

Free vs WPS Premium

Capability	Free	WPS Premium
MINUTE function	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Additional advanced office features	Available within the free scope shown on the product page	Includes more advanced features and extended benefits
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
Everyday formula learning and basic spreadsheet work	Free	The MINUTE function itself is available directly and fits routine time-splitting tasks
More cloud storage or broader office features	WPS Premium	Suitable if you also work with more documents, templates, or extended features

WPS membership center: Subscribe now