MINUTE in WPS on Windows: Introduction

Last updated:July 23, 2026

MINUTE is a time function in WPS for Windows that extracts the minute value from a date or time in DBSheet formula fields; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

MetricValueNotes
Core tasks3Matches the number of rows in the How-to Index
Available without membership3Matches the number of Free rows in the index
Membership-related items0Matches the number of membership-related rows in the index

About This Feature

Overview

MINUTE is a date and time function available in DBSheet formula fields in WPS Office for Windows. It extracts the minute portion from a date or time value and returns an integer from 0 to 59.

This WPS function is useful when you need to split time values for record-based calculations, build time logic in a database-style table, or use the minute result inside nested formulas.

Core capabilities include:

  • Extracting the minute value from a date or time field.
  • Returning a numeric result from 0 to 59 for further calculation.
  • Working inside nested formulas with other functions.

System Requirements

ItemRequirement
Operating systemA Windows device that can run WPS Office normally
App versionIt is recommended to use the latest version of WPS Office
NetworkNo mandatory internet connection is required for local formula calculation; downloading, installation, and account actions require internet access
OtherYou need an editable DBSheet and permission to add or edit formula fields

Download & Installation

ItemDetails
Official DownloadWPS Office Free Download
Post-install CheckOpen WPS Office, enter DBSheet, and confirm that you can add a formula field

Source: WPS download page

Compare with Alternatives

DimensionWPSMicrosoftGoogleNotionAdobe
Capability SummaryExtracts the minute value from a date or time in a DBSheet formula field, returns 0–59, and supports nested use with other functions.Excel MINUTE(serial_number) returns the minute of a time value as an integer from 0 to 59.Google Sheets MINUTE(time) returns the minute component of a specific time in numeric format.Notion formula minute(date) returns the minute of a date, from 0 to 59.Adobe ColdFusion Minute(date) gets the minute value from a date/time object.
WPS AdvantagesAdvantage: MINUTE works directly in DBSheet formula fields, so the result can be used in record-level automation and follow-up calculations inside the same table.Compared with WPS: Excel focuses on worksheet cell formulas, while WPS here is used in DBSheet record fields.Compared with WPS: Google Sheets focuses on spreadsheet cell formulas, while WPS here fits structured DBSheet field calculations.Compared with WPS: Notion also supports minute extraction, but the formula context is mainly database properties rather than a WPS DBSheet workflow.Compared with WPS: Adobe documents this as a CFML development function, not as a built-in table formula experience for business records.
Official SourceMINUTE functionMINUTEFormula syntax & functionsDate and time functions

Overall Conclusion
If you use WPS on Windows to manage records in DBSheet, MINUTE is a practical way to extract minute values for downstream calculations. Compared with spreadsheet cells or developer-oriented date functions, it fits record-based formula fields more directly.

Use Cases

#ScenarioTarget UsersCore Pain PointSolution
1Splitting check-in timesHR and admin teamsThey need the minute part from a full date-time valueUse MINUTE in a formula field to extract the minute value
2Processing business records by timeOperations and project teamsRecords include full date-time values, but later logic only needs minutesUse the MINUTE result as a condition or calculation input
3Building nested time formulasData managersThey need to combine minute values with other formula resultsNest MINUTE with other functions in the same formula field

Membership & Benefits

Free vs WPS Premium

FeatureFree UserWPS Premium
Use the MINUTE function✅ Available✅ Available
Basic PDF features✅ Available✅ Available with broader related tools
Cloud storage1 GB20 GB or more, depending on plan
AI and more PDF toolsLimited or not includedMore related tools are available, depending on plan

Source: WPS Office pricing page

Recommendations

Use CaseRecommended PlanReason
Everyday use of MINUTE and other basic DBSheet formulasFreeThe MINUTE function itself has no membership restriction
You also need more PDF tools, cloud storage, or AI-related featuresWPS PremiumBetter suited for broader document and storage needs

How to Subscribe

Source: WPS Office pricing page