A Time field holds a time of day with no date attached. Think of the time printed on a schedule: 02:00 every night, whatever the date.
Here is the test: is the answer a clock time that repeats, with no date? If yes, you want a Time field. For a point on the calendar, use a Date field. For a length of time, use a Duration field.
Example: a Systems table with a field called Daily Backup Time. Each system records when its nightly backup runs. The operations lead checks that every backup finishes before the business day starts.
The Daily Backup Time field in a system record, showing 2:00 AM with the clock icon beside the label.
Plan Availability | All plan types. |
Permissions | Solution Managers and Workspace Administrators can create, modify and manage Time fields; members with edit access to the record enter values. |
Platform | Web |
Related Reading |
Adding a Time Field Type
In Grid View, select the + at the right end of the column headers. From an open record, select + Add new field to this Table at the bottom instead.
Select Time. You can type to search the list of field types.
Name the field. In this article it is Daily Backup Time. A field name can hold up to 50 characters, and there is no restriction on the characters it can contain.
The field settings panel opens. It has three tabs: Settings, Defaults and Help Text. There is no AI Field Agent tab. The rest of this article takes them in that order. Save at any point with Add Field (or Update Field on a field that already exists) and come back to the other tabs later.
The field settings panel, Settings tab, with the Display Format preview, the note about the user's profile and the Require an entry switch.
Settings
The Settings tab is short. Top to bottom: Display Format and Options.
Display Format
A preview of the current time in your own format, such as 8:29 PM. There is nothing to choose. A note under it reads "Times are displayed in the format that has been defined in each User's Profile."
Note: The 12-hour or 24-hour clock follows each member's locale, not the field. The stored time is the same for everyone; one member sees 2:00 PM and another sees 14:00. The setting is under My Profile, General Preferences, Locale. See Setting My Locale.
Options
One switch, off to start.
Require an entry in this field. On, the field shows a Required label and a record cannot be saved until a time is entered. The field turns red with the message "Time is required". Turn it on for Daily Backup Time, because a system with no backup time is a system nobody has checked.
Defaults
Default Time is the time every new record starts with. The box reads HH:MM until you type one.
Note: Defaults apply to new records only. Records that already exist do not change when you set or change a default.
Daily Backup Time defaults to 02:00, the standard backup window. Most systems keep it, and the exceptions are changed by hand.
Help Text
A note for the person filling in the record, up to 800 characters. Help Text Appearance shows it As A Tooltip (the default, behind an info icon next to the field name) or Below The Field Name (always visible).
Write it for someone who has never seen the field. For Daily Backup Time: "The time the nightly backup starts, in the system's own time zone. Type 14:30 for an afternoon time."
Permissions
Field Permissions. Every field can carry its own permissions, which control who can see the field and who can edit it. Open the column menu and select Edit Field Permissions. Let Operations edit Daily Backup Time while everyone else reads it. See Field Permissions.
Dynamic Record Permissions. A Time field can also drive record-level rules: who can see or edit a record based on the value it holds. Every field type except Button can drive a rule. See Dynamic Record Permissions.
Using the field in views and records
In a record, select the field and a list opens in 15-minute steps: 12:00 AM, 12:15 AM, 12:30 AM and so on. Pick one, or type in the box under the list. Typing filters the list, and Enter sets the time. In Grid View, double-click the cell and the record opens with the same picker. The saved value shows centered in the cell.
The field converts common forms. Type 1pm and it stores 1:00 PM. Type 115 and it stores 1:15 AM, because a time with no "pm" is read as morning. Type 13:00 and it stores 1:00 PM, which 24-hour members see as 13:00. A value that is not a time, such as 25:00, is cleared rather than saved. The time is stored as a plain clock time: 14:30 written is 14:30 read back, in a record and in a formula.
Tip: Type times in the 24-hour form, such as 02:00 or 14:30, to avoid the morning default. 230 is read as 2:30 AM.
The time picker in a record, with the 15-minute list and the typed value 2:00 AM filtering it.
Filtering
The operators are equal to, not equal to, greater than, less than, equal to or greater than, equal to or less than, is empty and is not empty. "Daily Backup Time is equal to or greater than 5:00 AM" lists the backups that run into the business day. Spotlight uses the same operators, and Find searches the times.
Grouping
Group by this Field puts one group per time, plus (Empty). Systems that back up at the same time sit together, so a crowded backup window is easy to see.
Sorting
Sort 1 → 9 or 9 → 1 from the column menu. Sort 1 → 9 puts empty values first, then the earliest time to the latest.
Counting and rolling up
The field works in Lookup fields, in the filters of Lookup, Count and Rollup fields, and on the cards of Linked Record fields. A Lookup on a Backup Jobs table shows each job's system time beside the job.
Formulas
A formula reads the time as text, such as 14:30. The text functions work: CONCAT, TEXT, LEFT and LENGTH, as do IS_NOT_NULL, IFNONE and = comparisons. HOUR, MINUTE and DATEADD do not accept a Time field. See Formula Field.
Automations
An Update records or Create a record action can write the field. A condition can test it: equals, not equals, changes and is empty. See Automation Actions explained.
Forms
A Time field can be placed on a form. See Form View.
Editing a Time field
Change a time. Open the record, select the field, pick from the list or type, then save the record.
Clear a time. Select the x in the box under the list, then save.
Make it required. Open Modify Field Settings, turn on Require an entry in this field, then Update Field.
Change the field type. The dropdown at the top of the panel turns a Time field into Text, Text Area or SmartDoc. See Changing a Field's Type.
Delete the field. Open the column menu and select Delete Field. The times go with it. Deleted fields sit in the Recycle Bin for 30 days.
Frequently asked questions
How do I show times in 24-hour format?
How do I show times in 24-hour format?
It is a member setting, not a field setting. Choose a locale with a 24-hour clock under My Profile, General Preferences. Every Time field then shows 13:00 for you; other members keep their own format.
What happens when I type 115?
What happens when I type 115?
The field stores 1:15 AM. Add pm, or type 13:15, for an afternoon time.
Can I add a date to the time?
Can I add a date to the time?
Not in this field. Put a Date or Due Date field beside it, or use a Date field with time included.
Can I make a Time field required?
Can I make a Time field required?
Yes. Turn on Require an entry in this field and a record cannot be saved without a time.
Does the time change with a member's time zone?
Does the time change with a member's time zone?
Yes. The time shows in each member's time zone, so members in different time zones see different clock times for the same value. The clock format follows the member's locale.
Need more help? Ask the SmartSuite Community, where builders, administrators and the SmartSuite team answer questions about building on SmartSuite. For your account, billing or data, select the chat button in the lower-right corner of SmartSuite to reach support.
Last verified 1 Nov 2026.



