Imagine you manage a sports club and want to track the starting time and ending time of training sessions in your database. In this case, the Time columns will help you indicate the time in a suitable format.
If a column contains data that doesn’t look or behave the way you want, you can edit the column’s General Properties and the properties defined by the column type.
If a column contains data that doesn’t appear or behave as desired, you can edit the column’s General Properties.
Properties defined by the column type:
- This property allows a user to specify the format in which the time value will be represented. The following options are possible:
- HH:MM - time is displayed in the hours:minutes format;
- HH:MM:SS - time is displayed in the hours:minutes:seconds format.
- When the Help text property is filled in, a question mark is displayed near the field name on the View/Edit form. If you point to this question mark, a pop-up with a tip or a help text message will be shown.