mallikai Posted January 3, 2002 Share Posted January 3, 2002 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 Link to comment Share on other sites More sharing options...
LiveOak Posted January 3, 2002 Share Posted January 3, 2002 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8170 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now