Jump to content

time value list


mallikai

This topic is 8232 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

This topic is 8232 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.