Data entry filter for time field? Also delete seconds value?
How do I create a data entry filter for a time field so that a user can enter "0845" and the field will automatically format it as "08:45"?
Related to this, the time is automatically entered in the field when a new record is created. This time displays as "08:45", but when the field is clicked, the time displays as "08:45:26". I don't need the seconds and the user may be confused and think a seconds value also must be entered. Is there any way to prevent this seconds value from being entered automatically when a new record is created, or simply not display it when the field is modified? Would this be related to the data entry filter I want to add to this time field?