Duration (in hh:mm) entry field

[ianburgess]

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

[Bruce]

have you tried the picture as @t1 ?
It's been a while, but I _think_ netalk allows for values over 23:59 ....

[ianburgess]

Thnks for the suggestion, but @T1 won't go past 23.:59.