MINUTE in WPS on Windows: Introduction

Last updated:July 20, 2026

MINUTE in WPS on Windows returns the minute part of a time value; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

MetricValueNotes
Core tasks4Matches the number of rows in the How-to Index
Available without membership4Matches the number of Free rows in the index
Membership-related items0This topic does not require membership

About This Feature

Overview

The MINUTE function in WPS Office for Windows helps you extract the minute part from a time or date-time value in a spreadsheet. For everyday spreadsheet work, it returns an integer from 0 to 59 and supports basic time breakdown tasks in WPS Office.

Core tasks in this guide include:

  • Extracting the minute from a standard time value for attendance, schedules, or logs.
  • Returning the minute from a cell that contains both date and time.
  • Using the result in follow-up calculations, filtering, or checks.
  • Viewing formula hints while entering MINUTE to reduce basic input errors.

System Requirements

ItemRequirement
Operating systemA Windows device that can run WPS Office
App versionIt is recommended to use the latest version of WPS Office
NetworkNo mandatory internet connection is required for local formula calculation; internet access is needed for download and installation
OtherWPS Office should be installed, and you should be able to open and edit spreadsheets

Source: System Requirements for WPS Office

Download & Installation

ItemDetails
Official DownloadWPS Office Free Download
Post-install CheckOpen WPS Office, open a spreadsheet, and type =MINUTE(...) in a cell to check whether the function hint appears

Installation steps:

  1. Open the official WPS Office download page.
  2. Download the Windows installer.
  3. Run the installer and complete the setup by following the on-screen instructions.
  4. Open WPS Spreadsheet after installation and start entering formulas.

Source: WPS Office download page

Source: Download and Install WPS Office on PC

Compare with Alternatives

DimensionWPSMicrosoftGoogleNotionAdobe
Capability SummarySupports the MINUTE function in WPS Spreadsheet to return the minute part of a time value for basic time extraction and calculation.Excel provides MINUTE(serial_number) and returns the minutes of a time value as an integer from 0 to 59.Google Sheets provides MINUTE(time) and returns the minute component of a time value, with specific rules for literal time input.Notion formulas support minute(date) to return the minute from a date value, mainly in database property formulas.Adobe Acrobat official product pages focus on PDF editing, conversion, signing, and organization rather than spreadsheet minute extraction functions.
WPS AdvantagesAdvantage: You can extract minutes directly in WPS Spreadsheet for daily spreadsheet tasks, and this formula topic is available without membership.Compared with WPS: It also supports minute extraction, but the official guidance is centered on Excel function syntax.Compared with WPS: It also supports minute extraction, but the official notes say MINUTE(12:00:00) can return an error.Compared with WPS: It can return minutes in database formulas, but the main use case is database properties instead of a traditional spreadsheet grid.Compared with WPS: Its official workflow is centered on PDFs, not spreadsheet formulas.
Official SourceMINUTE functionMINUTEFormula syntax & functionsAdobe Acrobat

Overall Conclusion
If your work focuses on basic time extraction in a Windows spreadsheet, MINUTE in WPS on Windows is a direct fit. Microsoft Excel and Google Sheets offer similar function support, Notion is more database-oriented, and Adobe Acrobat is aimed at PDF workflows rather than spreadsheet formulas.

Use Cases

#ScenarioTarget UsersCore Pain PointSolution
1Attendance time breakdownHR and admin staffNeed to isolate the minute from check-in timesUse MINUTE to return the minute value
2Log timestamp cleanupOperations and support teamsFull timestamps are harder to review by minuteExtract the minute from date-time cells before sorting or counting
3Follow-up formula logicSpreadsheet usersNeed to reuse the minute in checks or calculationsCombine MINUTE with other formulas
4Formula learningNew usersNeed a simple way to learn time function syntaxType =MINUTE( to view the function hint

Membership & Benefits

Free vs WPS Premium

FeatureFree UserWPS Premium
Basic use of the MINUTE function✅ Available✅ Available
Basic spreadsheet editing in WPS Office✅ Available✅ Available
More PDF tools, templates, and some advanced capabilitiesPartially limitedMore benefits are available

Source: WPS Office pricing page

Recommendations

Use CaseRecommended PlanReason
Daily spreadsheet time extractionFreeThis topic covers a basic formula and does not require membership
Broader document and PDF needsWPS PremiumSuitable if you also need more PDF, template, or other suite benefits

How to Subscribe

Source: WPS Office pricing page