I am attempting to setup an hours calculation format.

My question is -

Is there any way to set up the time fields (for in/out times) that are quick data entry - without having to be military time or having to enter AM PM. If it could be done without the colon that would be great, too. I want my data entry person to only have to key numbers - it goes faster and is easier to remember.

Is there a conversion method that I am missing or something that will take a field entered as a number and put it to being a time?

Much thanks in advance for any help.

[ July 27, 2001: Message edited by: Zaphod ]

Time fields will accept some fairly loose data, i.e.: entering "18" will display as "18:00" (24 hour) or "6:00 PM" (12 Hour), depending on how the field is formatted for display. Entering "6pm" will show the same results. Unfortunately, entering hours:minutes (i.e., "6:15 PM") still requires putting ":" to separate hours and minutes.

I'm not exactly sure what you're trying to do, but if you are setting up something like a check in/out system, one way to do this would be to setup a simple script:

Set Field(TimeIn,Status(CurrentTime))

Then create a button next to the field that would run that script. Then just a simple click of the button would enter the time with no fuss.

You could also do this with an entry (text) field and some calculation fields to convert the entry field to a valid time, but it would require either some strict entry rules, or the calculations would require a lot of error trapping and case rules.