Download WPS Office for your device

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, ....

1. How to correctly express the time and date in the function formula2. Share the function formula to extract the year, month, day and hour, minute and second3. Real case: how to use the DATEIF function to calculate the length of service of employees4. How to convert different time units to each other

WPS Writer allows users to add various styles of header and footer, including text, pictures, and date and time. So how can we realize inserting date and time? A footer has been added to this document. So here we take the header as an example to show how to insert date and time. Get into the Header/Footer tab and click Date and Time to pop up the dialog. On the left-hand side of the dialog, we can choose from different formats to present the date and time. Check the Update automaticall....

WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently. Today, we are going to introduce basic usages of three commonly used date functions. They are namely the TODAY function, NOW function, and DATEDIF function. We can use the date function to insert the current date and time quickly. Also, we can use this function to update it in real-time. We can also make a countdown calendar with it. · ....

If other people revise a document, we can use the review feature to view the revisions. Take this paper as an example. It is revised by two people.If we only want to read Miss Chan's comments, here are the steps. In the Review tab, click the Review drop-down button and click Reviewers. Check your desired reviewer.Then Miss Chan's comments are displayed on the right. Sometimes, a paper may go through multiple revisions and comments.If we only want to read the latest comments, we....

A well-formatted presentation file can better your speech, and properly adding animation effects can help capture the audience's attention. So how can we customize the animation? Take these slides as an example.1. Click the Animation tab at the top, then the Custom Animation task pane will pop up on the right side of the screen. Now we click Selection Pane.2. In the Selection Pane task pane, we can see all the elements of the current slide page.3. Click the eye icon on the right to....

We can use the caption feature to number and annotate images, charts and other contents referenced in a document. So how do we use this feature? We take the image in this document as an example. Select the image, click References, and then click Caption to get a pop-up dialog.Click the Label pull-down to select the label you want. If none is available, you can click New Label to customize a label such as a Picture.Then select the Position of the caption. Click the Numbering button, you....

A PivotTable has a flexible operation interface. We can change the layout of various types of reports only with mouse operation. It can help us better search for information and make decisions.Take this table as an example. This is the sales data of a certain company over a period of time. If we want to count the total sales of products sold by each branch, we can use the pivot table to count it quickly. This is the completed pivot table. 1. First, select any cell with data in this tab....