projecttoday
Programmer
I have a form for employees to enter their time worked. I need to have a field where they can enter the lunch time they took in hours and minutes. If I define a field as Date/Time and use Short Time as the input format, an entry of 00:45 (45 minutes) goes into the table as 12:45:00 AM. Not good. So I changed the field format to Number with 2 decimals. With the same short time input format on the form, an error message occurs on entering 00:45.
I need to be able to enter the time in hours and minutes and store it correctly. Does anyone know how to do this without using 2 separate fields?
Robert
I need to be able to enter the time in hours and minutes and store it correctly. Does anyone know how to do this without using 2 separate fields?
Robert