How to Use WPS Multidimensional Time Field on Windows

Last updated:July 23, 2026

Use WPS Multidimensional Time Field through 3 topics: create a time field, set the time format, and enter time values; choose a topic from the index and follow the steps to complete it.

How-to Index

No.TopicMembership Requirement
11. Create a Time FieldFree
22. Set the Time FormatFree
33. Enter Time ValuesFree

How-to Guide

1. Create a Time Field

Entry: Click the + button on the right side of the table header → choose Time

  1. Open the multidimensional table that you want to edit.
  2. Click the + button on the right side of the table header.
  3. In the field type list, select Time.
  4. Enter the field name.
  5. Click OK to finish creating the field.

Success Criteria

  • Interface result: a new time field column appears in the table.
  • What you can do next: you can open field settings or start entering time values in cells.

Tips While Using

  • Common mistake: if you choose another field type by mistake, remove it and add the time field again.
  • Permissions: you need edit permission for the current multidimensional table.

2. Set the Time Format

Entry: Right-click the field title → Field Settings → Format

  1. Right-click the title of the existing time field.
  2. Select Field Settings.
  3. Open the Format option to view available time display styles.
  4. Choose 24-hour or 12-hour format as needed.
  5. Click OK to save the setting.

Success Criteria

  • Interface result: time values in that column are displayed in the selected format.
  • What you can do next: existing and newly entered values follow the current display format.

Tips While Using

  • Common mistake: changing the format changes how the value is displayed, not the stored time itself.
  • Suggestion: use one shared format across the team for clearer collaboration.

3. Enter Time Values

Entry: Click the target cell → use the time picker or input box

  1. Click the target cell in the time field column.
  2. In the time picker, choose the needed hour, minute, and second.
  3. For faster entry, you can also type the time manually in the input box.
  4. Confirm the value to save it.

Success Criteria

  • Interface result: the cell shows the entered time value.
  • What you can do next: you can continue copying, sorting, or filtering time data in the column.

Tips While Using

  • Common mistake: when entering time manually, keep the input consistent with the current field format.
  • Suggestion: if you are unsure about the format, use the time picker first.