How to Use WPS Multidimensional Time Field on macOS

Use WPS Multidimensional Time Field through 5 how-to topics, including creating the field, setting the format, entering time, choosing the right field type, and using automatic system time fields; 5 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Create a time field

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

1. Click the + button on the right side of the table header.
2. Select Time from the field type list.
3. Enter a field name.
4. Click OK to finish.

Success Criteria

• Interface result: A new time field column appears in the table.
• Next action: You can open field settings or start entering time values.

Tips While Using

• Common mistake: If you choose another field type, the column will not display as a time field.

2. Set the time format

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

1. Right-click the time field title.
2. Select Field Settings.
3. Open the Format options.
4. Choose either 24-hour or 12-hour display.
5. Click OK to save the setting.

Success Criteria

• Interface result: Time values display in the selected format.
• Next action: Later entries follow the current display format.

Tips While Using

• Common mistake: Changing the format affects display only and does not change the meaning of existing time records.

3. Enter time values

Entry: Target cell → time picker

1. Click the target cell.
2. Select the hour, minute, and second in the time picker.
3. Confirm the selection to finish entry.
4. If needed, type the time manually in the input box.

Success Criteria

• Interface result: The cell shows the entered time value.
• Next action: You can continue editing, sorting, or filtering this field.

Tips While Using

• Common mistake: When typing manually, keep the input consistent with the current field format.

4. Choose between a time field and a date field

Entry: Create a field or open field settings

1. Decide whether you need to record only time or both date and time.
2. If you only need hours, minutes, and seconds, choose a Time field.
3. If you need both date and time, choose a date field and enable the related time display option.
4. Save the field settings and start entering values.

Success Criteria

• Interface result: The field type matches the record requirement.
• Next action: Later filtering, display, and analysis fit the scenario better.

Tips While Using

• Common mistake: Time fields and date fields are separate types and should not be mixed directly.

5. Use Created Time or Last Modified Time fields

Entry: Advanced field list

1. Open the add-field entry.
2. Find Created Time or Last Modified Time in the advanced field list.
3. Add the field you need.
4. Check the automatically recorded time after a record is created or updated.

Success Criteria

• Interface result: The system field shows the creation or modification time automatically.
• Next action: You can use system time fields together with a regular time field.

Tips While Using

• Common mistake: These system fields are filled automatically and cannot be edited manually.