Time

The Time field stores durations, like task time or response time, and shows them in milliseconds, seconds, minutes or text.

For instructions on how to access field types or how to add one, see Field Types.


Time screenshot

Capabilities

  • Record how long something takes, such as task duration or logged hours
  • Display the value in different formats: milliseconds, seconds, minutes, or text
  • Use the value in formula or summary fields to calculate totals and averages
  • Mark the field as required to ensure duration is always filled in

Use Cases and Examples

  • Operations teams can log how long each step of a process takes per record, then use a summary field to calculate the total or average duration across all records.
  • Support teams can track time spent resolving each ticket, making it easy to report on average resolution time.
  • Project managers can record estimated and actual task durations in separate Time fields to compare planned versus real effort over time.
  • Freelancers or service teams can use the field to log billable hours per client record and roll up the total with a summary field.

Field options

Show as
Controls how the value is displayed in the table. Options include Miliseconds, Seconds, Minutes, and Text.

Tooltip
Adds a help text shown when the user hovers over the field name.

Required field
Prevents saving a record if this field is left empty.

Time: Prevents saving a record if this field is left empty






































Keep in mind

  • The Time field stores duration, not a time of day. Use a Date field if you need to record when something happened.
  • The Show as setting changes how the value is displayed, but the underlying data is always stored the same way: changing it later won't affect existing values.

FAQ

1-Can I do math with Time field values, like summing durations?

Yes, you can use formula fields or summary fields to add or average duration values across records.

2-What format should I use when entering a value?

You can type in the format shown in the field (e.g., seconds as a number, or HH:MM:SS depending on the "Show as" setting).

3-Is there a maximum duration I can enter?

There is no documented maximum: the field supports large duration values.