NetTalk Central

Author Topic: Duration (in hh:mm) entry field  (Read 3357 times)

ianburgess

  • Full Member
  • ***
  • Posts: 119
    • View Profile
    • Email
Duration (in hh:mm) entry field
« on: September 09, 2012, 11:50:00 PM »
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

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11254
    • View Profile
Re: Duration (in hh:mm) entry field
« Reply #1 on: September 10, 2012, 05:17:52 AM »
have you tried the picture as @t1 ?
It's been a while, but I _think_ netalk allows for values over 23:59 ....

ianburgess

  • Full Member
  • ***
  • Posts: 119
    • View Profile
    • Email
Re: Duration (in hh:mm) entry field
« Reply #2 on: September 10, 2012, 05:29:38 AM »
Thnks for the suggestion, but @T1 won't go past 23.:59.