Registered: 1257427069 Posts: 6
Reply with quote
I am migrating an MS Access time sheet over to Metastorm. In Access, several form fields (ie Time Worked, Meetings, etc.) are set with a Short Time format (HH:MM) and it masks the input data automatically. User does not need to type in colon, just 2 digts for Hours & 2 digits for Minutes. I cannot seem to replicate this on the Metastorm form. I tried both Time format, which defaults to wall time not hh:mm, and using a text field with the mask of hh:mm, however the user must key in the colon. Is there a way to replicate this in Metastorm? I also need to sum up the individual times (7 total) which need to be less than the Time Worked value.
Any and all suggestions greatly appreciated.
Registered: 1158198299 Posts: 5,507
Reply with quote
I am pretty certain you can type in 1320 into a time field and it becomes 13:20. We do this in version 6, and have just moved that system to version 9, and we can do it, so I suspect version 7 you can too.
You need to have the system set up to use 24 hour times, but I prefer these anyway as they are neater (and easy for anyone except Americans to use). Having said that, I have a timesheet app I built a long time ago for internal use. Because of the problems doing any calculations with time fields, it accepts hours and minutes as two separate integer fields. Awkward, but the only way to manage proper calculation (as you cannot 'add' times - if the total goes over 23:59 hours, even in excel, the answer is meaningless). the procedure is in version 6 and I do not have a version 6 installation I can use to convert it right now, so I cannot post it, sorry. __________________ Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.