i am using an fmpro 5.5 database for our company's timesheets..

i have a value list for start time and end time with time in increments of 15 minutes and i have the next field calculating the start time from the end time to reveal total hours...

i have the start time and end times list in military format and when entered the field changes to 12 hour regular format..

however is there a way for the value list to just show 11, 12, 1 and not 11, 12 13 AND still calculate the end time from the start time correctly?

thanks

Only if you limit the possible hour entries, otherwise how is FM to know that when you enter 1 you mean 13 and not 1? You could have a value list with text values 1AM, 2AM, 3AM... 11PM, but you must do something to eliminate the ambiguity between AM and PM.

-bd