Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Entering time in hours and minutes

Status
Not open for further replies.

projecttoday

Programmer
Feb 28, 2004
208
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top