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
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | 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 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
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office normally |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No mandatory internet connection is required for local formula calculation; downloading, installation, and account actions require internet access |
| Other | You need an editable DBSheet and permission to add or edit formula fields |
Download & Installation
| Item | Details |
|---|---|
| Official Download | WPS Office Free Download |
| Post-install Check | Open WPS Office, enter DBSheet, and confirm that you can add a formula field |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Extracts 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 Advantages | Advantage: 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 Source | — | MINUTE function | MINUTE | Formula syntax & functions | Date 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
| # | Scenario | Target Users | Core Pain Point | Solution |
|---|---|---|---|---|
| 1 | Splitting check-in times | HR and admin teams | They need the minute part from a full date-time value | Use MINUTE in a formula field to extract the minute value |
| 2 | Processing business records by time | Operations and project teams | Records include full date-time values, but later logic only needs minutes | Use the MINUTE result as a condition or calculation input |
| 3 | Building nested time formulas | Data managers | They need to combine minute values with other formula results | Nest MINUTE with other functions in the same formula field |
Membership & Benefits
Free vs WPS Premium
| Feature | Free User | WPS Premium |
|---|---|---|
| Use the MINUTE function | ✅ Available | ✅ Available |
| Basic PDF features | ✅ Available | ✅ Available with broader related tools |
| Cloud storage | 1 GB | 20 GB or more, depending on plan |
| AI and more PDF tools | Limited or not included | More related tools are available, depending on plan |
Source: WPS Office pricing page
Recommendations
| Use Case | Recommended Plan | Reason |
|---|---|---|
| Everyday use of MINUTE and other basic DBSheet formulas | Free | The MINUTE function itself has no membership restriction |
| You also need more PDF tools, cloud storage, or AI-related features | WPS Premium | Better suited for broader document and storage needs |
How to Subscribe
- WPS membership page: Subscribe now
Source: WPS Office pricing page