A very quick update on a new feature for the agileBase platform: if you have a field which is a time duration, it can now be entered in hh:mm format. This can be useful for applications like time logging.
To set this up, create a decimal number field to use as the time duration. Edit the options and tick ‘use duration’.
In the user interface, people will see an hh:mm data entry box. However when data is saved, it will be stored in the database as a decimal number representing fractions of an hour. So for example
01:30
will be transformed into 1.5 i.e. one and a half hours. That means reporting, charting and data analytics can all be used to total up time.
We hope this is useful to you and look forward to hearing your comments.
Source: Agilebase