Thanks, Tom. I have a user input sheet with 3 separate columns for
hour, min, and AM/PM. I then convert the entries on a separate sheet
to the proper time using the timevalue function.
We did several tests with the users to see what input format would be
the fastest for them, as they must input data for hundreds of employees
and only have a specified time frame to do so. What we found is that
if the user must enter 08:30 AM, typing the semicolon slows them down
significantly and produces many errors. The fastest way for them to
enter the time is to enter the hour as a number, tab, then enter the
min as a number, tab, then enter AM or PM (which is already defaulted)
to AM so 9 times out of 10 they simply have to tab again and not enter
anything. The 12 hour check is done separately in the program.
Thanks again.