I need to enter data but it has to be put in as a timed event. Is there a way to make sure the data entered with a ":" is not calculated as a time of day?
Example
It took 12:34 (12 min and 34 sec) to do the report. (NOT 12:34 AM)
I want the data to be entered with mm:ss
BIG BUT!!! I don't want the user to be able to enter 12:74 (12 min and 74 sec). If they do I want it to calculate the correct time of 13:14 or at least give them an error.
Thanks,
Ken
Bookmarks