Brian Barker wrote:
At 10:23 08/12/2009 +0200, Dotan Cohen wrote:
I have a column formatted as "HH:MM". When the user enters "14" I need
it to be registered as "14:00" assuming a 24-hour clock. How can this
be achieved?
One obvious workaround is to have two columns: one in which the user
enters data and the second in which you want the values to appear
correctly - and from which you then do your calculations. You write a
formula to make the modified copy from the first to the second column,
and it is entirely up to you to decide on and achieve the conversion
that you desire. If you preferred, you could protect the second column.
I trust this helps.
Brian Barker
This setup is commonly used with manual input of growing lists and you
have to adjust the formula range(s) to the growing/shrinking list of
data which does not allow for column protection.
I know that Base is the worst database app on the planet, but I use a
flat, simple input table for my personal expenses since OOo 1.1 with a
connected (not imported!) dBase table without row limits, one input form
on a sheet for easy input, import ranges with automatic adjustment of
adjacent formula ranges and a group of data pilots connected to the
database.
A masked field in a database form makes the HH:MM entry obsolete.
Other spreadsheet formulas can adjust to the adjacent import list.
Unlike spreadsheet ranges, database tables have a clear start and a last
row with separate column labels.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
