Formatting time in WPS Spreadsheet

Uploaded time: November 18, 2021 Difficulty: Primary

Formatting time in WPS Spreadsheet

Formatting time in WPS Spreadsheet

Tips: After starting to play, you can adjust the video clarity, click

Quality

Auto 720p

Graphic skills

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.

_1.gif


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.

_2.gif


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

_3.gif


Did you get it?