time value list

[mallikai]

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

[LiveOak]

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