Am 31.10.2015 um 08:40 schrieb Gary Collins: > 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 >
Fill down =A1+1/86400 (with A1 being the start time) -- 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