SECOND in WPS on Windows: Introduction

WPS SECOND helps you extract the seconds part from a time value in WPS tables; 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

The SECOND function in WPS can extract the seconds component from a time value and return an integer from 0 to 59. It is useful for time parsing, formula-based checks, and combined calculations in table workflows.

Core capabilities include:

Extracting the seconds value from a time field for clearer time breakdowns.
Using SECOND directly in a formula field after the field is created.
Combining SECOND with other functions for broader time logic.

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 network connection is required for local formula calculation; downloading, installation, and account actions require internet access
Other	You need access to the table and permission to edit fields

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Office, open your table, and confirm that you can add a Formula field

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	WPS lets you use SECOND in a formula field to extract the seconds part of a time value for time parsing and combined calculations.	Excel provides the SECOND function and returns the seconds of a time value as an integer from 0 to 59.	Google Sheets provides SECOND(time) to return the seconds component of a specific time.	Notion formulas support date and time calculations and can add time in seconds, but they do not provide a same-name SECOND function.	Acrobat supports date and time formatting in PDF forms, but it does not provide a spreadsheet-style SECOND function.
WPS Advantages	Advantage: You can use SECOND directly in a WPS formula field and connect the result with other table fields in the same workflow.	Compared with WPS: Similar function coverage is available, but it is centered on worksheet formulas.	Compared with WPS: Similar function coverage is available, but valid time input formatting is more restrictive in formulas.	Compared with WPS: Time logic is possible, but users need other date functions instead of a direct SECOND function.	Compared with WPS: The workflow is focused on PDF forms rather than table formulas with a direct equivalent function.
Official Source	—	SECOND function in Excel	SECOND in Google Sheets	Notion formula syntax	Acrobat field formatting

Overall Conclusion
If you need to extract seconds inside a WPS table workflow on Windows, SECOND covers the common requirement directly in a formula field. Excel and Google Sheets offer closely related function behavior, while Notion and Acrobat are better suited to database logic or PDF form scenarios rather than a direct spreadsheet-style SECOND function.

Use Cases

No.	Scenario	Suitable for	Main issue	How SECOND helps
1	Splitting time fields	Data organizers	They need the seconds value separately for analysis	Use SECOND to return the seconds part
2	Building conditional time logic	Table builders	They need to combine seconds with other conditions	Combine SECOND with IF and related functions
3	Checking imported time data	Operations teams	Imported values are hard to verify quickly	Show the seconds result in a formula field for review
4	Refreshing results after edits	Team collaborators	Source time changes need updated results	Formula fields recalculate the SECOND result automatically
5	Creating time analysis columns	Project managers	They need multiple time dimensions for analysis	Use SECOND as one part of a time breakdown workflow

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Basic use of the SECOND function	✅ Available	✅ Available
Advanced PDF tools	Basic access	More advanced tools available
Cloud storage	1 GB	Higher-capacity plans available
Templates and extended tools	Partial access	Broader access

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Using SECOND and other basic table formulas in daily work	Free	It covers common time extraction and formula needs
Needing more PDF tools, cloud storage, or broader document benefits	WPS Premium	It fits users with broader document and collaboration needs

Membership page: Subscribe to WPS Premium