Re: [libreoffice-users] calc / numerical keypad

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: users+unsubscribe@global.libreoffice.org
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