Entering time durations

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s