Duration (Timeinterval)

Store an elapsed time span such as hours worked or response time.

Use a Duration field when the record should store a time span instead of a clock time or a date.

This works well for values such as hours worked, estimated effort, response time, or other elapsed time values.

For the general settings all data fields have in common, see Shared field settings.

Field-specific settings for Duration are:

General

• Default value:

  • Enter a static value directly in the field
  • Edit dynamic value next to the field opens the logic editor where you can add or edit the logic for that setting. After you save the script, Ninox shows the first line of the script instead of the static value field. To switch back to a static value, click Remove dynamic value on the right.

Display

• Duration format: controls how the duration is displayed

  • a mixed day-and-time value, with optional seconds or milliseconds
  • a total in days, hours, minutes, seconds, or milliseconds
  • a rounded or more precise value, depending on the selected format

Use Duration for elapsed time. Use Time for a clock time. Use Appointment when you need a timestamp for start and end.