Hi
I've got a column in calc 4.3.2.2 to contain the length of video clips; it's formatted to Time>876613:37:46. The first inconvenience is that, when using autoincrement the times are incremented not by 1 second but by 24 hours. Whilst i understand that this is due to the way date/time is stored, with the date as integer and the time as fraction, i think it is not exactly intuitive. I feel that it might be much more convenient if LO would take the formatting into account and increment by 1 second (or, to be more precise, by 1 LSD to the chosen format). Similarly, when entering such times i think it would be more helpful to give precedence to the LSD, so entering 8, for example, would be interpreted as 8 seconds (rather than 8 hours as is cuŕrently the case) and 8:40 as 8m40s. Again, this interpretation should be format dependent. What does anyone else think? Best /Gary -- To unsubscribe e-mail to: users+unsubscr...@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