Inconveniences of time format

users
#1

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

#2

Fill down =A1+1/86400 (with A1 being the start time)