Hi Brian,
Thank you for the answer.
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 ?
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.
Maybe I didn't write it clearly. The cell is formated [[HH]:MM first,
then I enter digits ( time).
I thought that cell format stimulates it, then IMHO automatic entering
of : after second digit seems natural to me (:-))
Adam
--
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