At 18:46 01/08/2013 +0200, Adam Noname wrote:
I use format [[HH]:MM for time. Then hour can be maximum 2 digit
number ( from 0 to 24 ). Is it possible for calc to add sign :
after every second number ? Or : is it possible for calc to use
sign : when I press key ./del on numerical keypad ?
Not as far as I know. Times are stored as numbers - as fractions of
a day - so any number you enter, even if it contains a point, is
interpreted as a number of days but then displayed in hours and
minutes, as you have chosen. Critically, it is the presence of the
colon that would indicate that you are entering a time in hours and
minutes, and I don't see how you can stimulate that interpretation without it.
The simplest workaround might be to enter just the digits of the time
- always including the units digit of minutes - into a column (let's
say column A) formatted as number. Then, in another column (say B),
you could calculate the required value in the appropriate
formula. In B1, enter:
=TIME(INT(A1/100);MOD(A1;100);0)
Fill this down column B and format the column as a time as you require.
If you prefer, you could format column A as 0:00, which would make
column A look like the times you require. But note that these would
still not be the genuine time values you require and you would still
need to calculate the column B values before you could calculate with
them successfully.
Note that you could hide column A after you have completed entering
your data. Alternatively, you could put the data entry column
somewhere out of the way - perhaps even on a separate sheet.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
