SECOND in WPS on Windows: Introduction

SECOND in WPS is a spreadsheet time function that extracts the seconds from a time value; 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

SECOND is a built-in time function in WPS Spreadsheet for Windows. It is used to extract the seconds portion from a time value during time splitting, data cleanup, and result checking.

Core capabilities include:

Enter the SECOND function and complete its argument to return the seconds from a time value.
Use formula prompts to check syntax and argument requirements while typing.
Let results update automatically when referenced data changes.

Common use cases include time-field splitting, log cleanup, and report calculations. It helps reduce manual parsing of time strings and keeps spreadsheet-based calculations easier to reuse.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	No mandatory network connection for local formula calculation; internet access is needed for download, installation, and account-related actions
Other	You need to open WPS Spreadsheet and edit formulas in cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Office, launch Spreadsheet, and type `=SECOND(` in a cell to confirm the function entry point is available

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Spreadsheet, `SECOND(time_value)` extracts the seconds from a time value, supports formula prompts during input, and updates with cell recalculation.	Excel provides `SECOND(serial_number)` and returns the seconds of a time value as an integer from 0 to 59.	Google Sheets provides `SECOND(time)` and returns the second component of a specific time in numeric format.	Notion formulas support date and time functions such as `hour()`, `minute()`, `formatDate()`, and `parseDate()`, but the help page does not list a same-name SECOND function.	Adobe Acrobat forms use JavaScript for formatting, calculations, and validation in PDF forms rather than spreadsheet functions.
WPS Advantages	Advantage: You can enter the function directly in a spreadsheet cell and use formula prompts while building the formula. Distinct: The result fits naturally into fill-down and cell-based spreadsheet workflows.	Compared with WPS: It also supports second extraction, with function details documented in Excel help pages.	Compared with WPS: It also supports second extraction, with date functions organized in the Google Sheets function list.	Compared with WPS: It is more focused on database formulas and property logic, so second extraction is usually handled through other date functions.	Compared with WPS: It is designed for PDF form scripting and field behavior, not a spreadsheet SECOND function workflow.
Official Source	—	SECOND function	Google Sheets function list	Formula syntax and functions	Using JavaScript in Forms

Overall Conclusion
If you need to extract seconds directly inside a spreadsheet, WPS, Microsoft Excel, and Google Sheets all provide a direct function path. Notion is better suited to database-style formulas, while Adobe focuses on PDF form scripting, so WPS remains a straightforward choice for spreadsheet-based time extraction on Windows.

Use Cases

No.	Scenario	Suitable For	Main Need	How WPS Helps
1	Splitting time fields	Data cleanup users	Need to isolate seconds from full time values	Use SECOND in a cell to return the seconds part
2	Formula checking	Spreadsheet users	Need to verify time-based calculations	Compare SECOND results with the original time value
3	Report calculations	Office and analysis users	Need to reuse time components in later formulas	Feed SECOND results into other formulas
4	Training demos	Learners and trainers	Need a simple example of a time function	Show the function prompt during formula entry
5	Batch fill-down	Daily office users	Need to process many rows of time data	Copy or fill the SECOND formula down a column

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Enter and calculate the SECOND function	✅	✅
Basic spreadsheet editing	✅	✅
Additional advanced benefits and extended services	Use the features included in the free offering	Access the benefits listed on the pricing page for the selected plan

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
Everyday time-function calculations	Free	The SECOND function itself is available for basic spreadsheet work
Broader office workflows with added benefits	WPS Premium	Useful when you also need additional advanced features and related services

WPS membership center: Subscribe now