I am contemplating adding a feature to my app that will take from 2-8 time entries and add them up.
It is important to note that the times entered are not calendar-related but rather, units of duration in the format "h:nn"
What I'm looking at is either a form to store the data entries or perhaps I'll just use an unbound form to perform ad-hoc calculations (addition) of multiple time durations. But what I'm ultimately after is this
- Does Zoho offer a quick and easy way to enter a time as some spreadsheets do? I don't want the user to have to use the "shift" key to enter the hour-minute seperator. Somehow I'd like to enter a time duration (in h:nn format) using only a simple numeric "keypad" that may be offered in iOS Zoho Creator. Seconds are NOT implemented in my application, only hours and minutes. The user will be transferring data into Zoho that is already available in h:nn format from other visual data source.
Perhaps an entry of
- "7.19" would be accepted to be 7 hours, 19 minutes (07:19:00)
- "10.1" would be accepted to be 10 hours, 1 minute (10:01:00)
Is this input functionality (or something similar in terms of ease and speed) incorporated into Zoho at this point in time or is a lot of custom formatting and coding going to have to be done? As I remember in my MS Access developer days, time duration entry into a time/date field was very easy and fast, and did not require the use of the ":" character however this was done on a full keyboard while on a desktop using the native software.
Ultimately, this application will mostly be performed from Android and iOS smartphones and pads and it will need to simple and intuitive and speedy, while using that device.
Then, once a number of these entries exist (either as saved data or from fields on an unbound form), I'll need to be able to add (sum) them together to come up with and display a total of time duration, in the format of h:nn
Thanks in advance