In an Access form, employees need to enter the number of hours they spent for specific activities.
In the table, a “Date/time” field is used. No format or input is specified in the table.
In the form the format is “short time” and the input mask is 00:00;0;_
When the value is 00:00 in the form, it is 12:00 in the table.
How can I have 00:00 as value in the table? Then I will be able to calculate the total of hours.