How to Use WPS Time Field on Windows

Last updated:July 21, 2026

Use Time Field with 3 how-to topics: create a time field, set the time format, and enter time. All 3 topics are available without membership.

How-to Index

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

How-to Guide

1. Create a Time Field

Entry point: + button on the right side of the header → Time field

  1. Click the + button on the right side of the header.
  2. In the field type list, select Time.
  3. Enter a field name.
  4. Click OK to finish creating the field.

Success Criteria

  • Interface result: a new time field column appears in the data table.
  • What you can do next: you can open field settings or enter time in cells in that column.

Tips While Using

  • Common mistake: choosing the wrong field type changes the later display and entry behavior.
  • Environment note: you need permission to edit fields in the current data table.

2. Set the Time Format

Entry point: right-click the field title → Field Settings → Format

  1. Right-click the time field title.
  2. Select Field Settings.
  3. In Format, choose the time display style you need.
  4. You can use a 24-hour format such as 14:30.
  5. You can also use a 12-hour format such as 2:30 PM.
  6. Click OK to save the setting.

Success Criteria

  • Interface result: time values in the field update to the selected display style.
  • What you can do next: later entries in this field follow the current field format.

Tips While Using

  • Common mistake: after changing the format, confirm that the display style matches your team’s usage habit.
  • Environment note: changing the field format affects the unified display style of that field.

3. Enter Time

Entry point: target cell → time picker

  1. Click the target cell.
  2. In the time picker, select the hour, minute, and second.
  3. To fill the current moment quickly, click Current Time.
  4. You can also type a time directly in the input box.

Success Criteria

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

Tips While Using

  • Common mistake: when typing manually, make sure the value matches the current field format.
  • Environment note: if the typed format does not match the field rule, use the time picker instead.