Time Columns

Say you manage a sport club and want to track in your database the starting time and ending time of trainings. In this case the Time columns will help you to indicate time in a suitable format.

If a column comprises the data that don't look or behave the way you want, you may edit column General Properties and the properties defined by the column type.

General Properties:

Properties defined by the column type:

Time Options

Column Property



This property allows a user to specify a format in which the time value will be represented. The following options are possible:

  • HH:MM - hours:minutes
  • HH:MM:SS - hours:minutes:seconds


When the Help text property is filled in, the question mark is displayed near the field name on the View/Edit form. If you point to this question mark, the pop-up with a tip or a help text message will be shown.

Next: Duration Columns