I need users to complete a "duration" field in the formatt of hh:mm, allowing up to 999 hours and I am wondering how best to do this.
The only two ideas I have come up with are:
1. Have separate hours and minutes fields - then duration needs to be calculated from them
2. Enter as a decimal and trap any decimal value over .59 and have a function that converts, eg. 1.30 to 1.50. I would also need to reverse the process to display durations.
Neither of the above is ideal - any suggestions welcomed.
Thanks