Traditional Culture Encyclopedia - Almanac inquiry - How to set the settlement time set by wps form?
How to set the settlement time set by wps form?
1. Open the WPS form software and select the cell that needs settlement time.
2. Select the cell format in the Format menu.
3. In the Cell Format dialog box, select the Time tab, and then select the desired time format, for example, hh, mm and ss represent hours, minutes and seconds.
4. Enter the start time and end time, for example, enter 9:00:00 in cell A 1 and 10:30:00 in cell A2.
5. Enter the formula in another cell, for example, enter =A2-A 1 in cell A3.
6. Press Enter to calculate the time difference. In this example, the result is 0 1:30:00. You can set the settlement time.
- Previous article:2020. 1.20 Gregorian calendar
- Next article:Laohuangli moving
- Related articles
- Who is the husband of the magic emperor's butler Luo?
- 2050 Gregorian calendar auspicious day query
- Is it cold on the 24th of the twelfth lunar month in 2020?
- How to send loquat without damage-perpetual calendar
- Old yellow calendar invitation code
- 2021654381October 20th, the eighth day of the twelfth lunar month, you know?
- When is the appropriate date for pigs to get married in September 2023?
- 202165438+February, which day is good to enter the house?
- Is it appropriate to enter the house this winter 18?
- Both the Year of the Sheep and the Lucky Year belong to the Year of the Sheep.