WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


Formatting time in WPS Spreadsheet

Uploaded time: November 18, 2021 Difficulty Beginner

Formatting time in WPS Spreadsheet

Formatting time in WPS Spreadsheet

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more.Today, we will learn how to format the time. Before setting, we need to be aware of the correct way to record time.

A complete-time duration consists of hours, minutes and seconds, and each value is separated by colons.

For example: 12:25:25.

Take this table as an example, select the cells A4-A14. Click the Number Format drop-down button in the Home tab, and select More Number Format. You can also use the shortcut key Ctrl+1.

Select Time in the pop-up dialog box, where there are several time formats that can be set.

Select your country at Regional settings. The AM and PM formats are available to be set in the Type.  After setting, click OK to apply it to the selected cell area.

Here is a tip: hold down crtl+shift+;  the current time can be quickly entered.

Did you get it?

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.