[libreoffice-users] Inconveniences of time format

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+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