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?